How to select nth record from a table?
- 13 Answers
- 36943 Views
- DELL, Microsoft, Ramco, I also Faced
- E-Mail Answers
Answer Posted / pallavi attarde
Here N is for Nth record.
SELECT TOP 1 * FROM
(SELECT TOP N * FROM
(SELECT Table.Coloumn1,Table.Coloumn2 from Table)
as d order by d.Coloumn1 desc) as p order by Coloumn1
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
What is a linked server in sql server?
What is 2nf normalization form?
how many clustered indexes can be created on a table? : Sql server database administration
What are the types of database recovery models?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
How to invoke a trigger on demand?
How to delete existing rows in a table?
Explain what is dbcc?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How to loop through returning rows?
What is user defined datatypes and when you should go for them?
What is sql server agent and what are the two modes of authentication in sql server?
How to connect to a sql server using odbc_connect()?
How to create a simple user defined function in ms sql server?
Please illustrate physical database architecture? : SQL Server Architecture
