How to select nth record from a table?
- 13 Answers
- 36906 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
Are null values the same as that of zero or a blank space?
What is the difference between an index and a unique index?
List out different types of normalizations in sql server and explain each of them?
What is temporal data type?
Can sql servers link to other servers?
What are the different types of sql server replication? : sql server replication
How to create a ddl trigger using "create trigger" statements?
Why use “in” clause in sql server?
Give an example of SQL injection attack ?
What are the advantages of using stored procedures in sql server?
What functions can a view be used to performed?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Explain a differential backup?
How to access the inserted record of an event?
What are the three different part of rdl file explain them?
