Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 41337 Views
- DELL, Microsoft, Ramco, I also Faced
- E-Mail Answers
Answer Posted / rathika
Answer #7 should be
select top 1 * from (select top n * from tbl order by col1
asc) tbl order by col1 desc
where n = nth number in the list
| Is This Answer Correct ? | 8 Yes | 7 No |
Post New Answer View All Answers
What is unpivot?
What are the basic functions for master, msdb, model, tempdb databases?
What is difference between temp table and cte?
What does sql server mean?
What is bit data type?
What are the properties of primary key?
What is partition in sql server?
Are connections to sql server encrypted?
What does indexation mean?
how we use window authentication connection with sql server.?
What is the federation in sql azure?
what is sql server? : Sql server database administration
What are four major operators that can be used to combine conditions on a where clause?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What is openxml in sql server?
