asp.net corner
Pages
Home
WITH Query in SQL Sever
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment