Spearcross

All About Programming, Piece of My Mind, And Anything

Here’s example to get 2nd row data with sql query

1
2
3
4
5
6
7

;WITH YourCTE AS
(
SELECT TOP 2
*, ROW_NUMBER() OVER(ORDER BY [YourColumn]) AS RowNumber
FROM [YourTable]
)
SELECT * FROM YourCTE WHERE RowNumber=2