How to select nth record from a table?
- 13 Answers
- 37066 Views
- DELL, Microsoft, Ramco, I also Faced
- E-Mail Answers
Answer Posted / pravin s. ahire
Select Top 1 *
From (Select Top N * from tablename order by
table.ColumnName desc)
-- where N = nth record
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to use column default values in insert statements in ms sql server?
What is a collation?
write an SQL query to list the employees who joined in the month of January?
What is difference between oltp and olap?
What is filter index?
What is bookmark link in ssrs?
What is the difference between dbcc indexdefrag and dbcc reindex?
can SSRS reports Cache results?
when would you go for denormalization? : Sql server database administration
What is difference between foreign key and unique key?
Does sql server 2000 clustering support load balancing?
What are different types of roles provided by ssrs?
How do you handle datasets larger than 50 gb?
Where is trigger in sql server?
What is SQL Azure Federations?
