How to select nth record from a table?
Answer Posted / roxy
select top 1 * from (select top n * from tbl order by col1
desc) tbl order by col1 asc
where n = nth number in the list
Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
Explain the usage of floor function in sql server.
Explain what is row_number function?
What is field with example?
What is the difference between row_number and dense_rank?
What is optimistic concurrency?
What is relationship? What number of sorts of relationship are there?
What is sparse columns of sql server 2008?
Which are new data types introduced in sql server 2008?
How can we determine what objects a user-defined function depends upon?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What is the command to change the recovery model?
What is difference statement and preparedstatement?
How to create indexed view?
What were the latest updates to SQL Azure service?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?