Select nth record from a table
|
Jak
858
Points
132
Posts
|
Hi, I have a table that have no any unique record, I want to get 10 th record.
Views:
9058
Total Answered: 1 Total Marked As Answer: 1 Posted On: 17-Sep-2014 22:52 Share: 
|
Answers
|
Rahul M...
4822
Points
23
Posts
|
Hi, try the following query: SELECT TEMP.[fieldname] FROM (SELECT ROW_NUMBER() OVER (ORDERBY [fieldname] ASC) AS rownumber, [fieldname] FROM [tablename] ) AS TEMP WHERE TEMP.rownumber =<rownumber>
Posted On:
17-Sep-2014 22:57
|
Blog
Active User (0)
No Active User!
