Sunday, September 23, 2012

Select 4th row in Sqlserver

Hi This is Simple example for getting 2nd or 4th row record frome SQL Server. Code: SELECT items FROM (SELECT ROW_NUMBER() OVER (ORDER BY items) AS RowNum, items FROM Tablename) sub WHERE RowNum = 4

No comments: