How to select nth record from a table?
- 13 Answers
- 36908 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 check constraint?
In what sequence sql statement is processed?
What are orphan records?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
Which are the new data types introduced in sql server 2008?
What is built-in function?
How do you Implement SSIS Packages in your Project?
Why variables called the most powerful component of ssis?
What is a result set object returned by mssql_query()?
What different steps will a sql server developer take to secure sql server?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is the current pricing model of SQL Azure?
How to create a local temporary stored procedure?
What is the ‘fillfactor’?
Explain the third normal form(3nf)?
