How to select nth record from a table?
- 13 Answers
- 36940 Views
- DELL, Microsoft, Ramco, I also Faced
- E-Mail Answers
Answer Posted / saravanan p
Select top 1 * from
(Select top n * from tbl order by column name asc)tbl1
order by column name desc
| Is This Answer Correct ? | 18 Yes | 12 No |
Post New Answer View All Answers
What is sql server programming?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
What is normalization of database? What are its benefits?
Why truncate is ddl command?
What is filtered index?
How to create hyperlink from returned sql query ?
What are the benefits of normalization?
What is the difference between rank and dense_rank?
Can group by and orderby be used together?
What is meant by datasource?
Do you know exporting and importing utility?
what is database replicaion? : Sql server database administration
What is the stuff and how does it differ from the replace function?
What is row_number()?
Explain about system database?
