SQL Server Education (by the geeks, for the geeks)
One of the most commonly asked interview question is to find nth max value in SQL Server. There are multiple solutions to this question. The below query creates a dummy table …
Find nth max value in SQL Server Read MoreHi Friends, This is from my old blog so dont give me credit for wirting something new 🙂 ———————- There is an alternative to TOP clause, which is to use ROWCOUNT. …
SQL Server: Alternatives to TOP clause – ROWCOUNT, ROW_NUMBER() Read More