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
what is denormalization? : Sql server database administration
What is the query and subquery?
What is a deadlock and what is a live lock?
Explain how to send email from sql database?
difference between Clustered index and non clustered index ?
What’s the distinction between dropping a info and taking a info offline?
What are indexes in sql?
Tell me about the approaches which you used to counter the DI problems.
what is a transaction? : Sql server database administration
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How to read data in a table with "select" statements?
How to provide default values to function parameters?
What is bcp? When does it used?
What is temporal data type?
What is the use of keyword with encryption.