Posts Skip Top N Rows from a table in Sql Server
Post
Cancel

Skip Top N Rows from a table in Sql Server

What if you want to skip Top N rows while doing a select statement in sql server? Try this

1
2
3
4
5
6
7
DECLARE @count INT = 5

SELECT *
FROM <<Table>>
WHERE <condition>
ORDER BY <<column>>
OFFSET @count ROWS

Hope this helped.

This post is licensed under CC BY 4.0 by the author.