Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 40865 Views
- DELL, Microsoft, Ramco, I also Faced
- E-Mail Answers
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 the syntax for encrypting a column in SQL Server?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What are a scheduled jobs or what is a scheduled tasks?
What is dirty read?
How many instances per computer are there in sql server 2000?
What is the use of builtinadministrators group in sql server? : sql server security
Why SQL Agent is used?
What is similarity and difference between truncate and delete in sql?
What is the Difference Between Primary and Foreign Key?
What is linked report?
Explain about service Broker functions?
What is the full form of ddl?
What is read committed?
Explain mixed authentication mode of sql server?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
