How to select nth record from a table?

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


Please Help Members By Posting Answers For Below Questions

What is the default Port No on which SQL Server listens?

600


Determine when to use stored procedure to complete sql server tasks?

518


Can we use where clause with group by?

496


How to declare and use cursor variables?

568


How do you delete a trigger?

561






How to assign null values to variables or columns?

522


Why use cursor in sql server?

528


How to update values in a table with update statements in ms sql server?

531


How can I check that whether automatic statistic update is enabled or not?

533


Explain the architecture of ms sql reporting service?

510


Why I have to use stored procedures?

567


How to make conditional sum in ssrs?

127


Tell me extended events in sql server 2008?

536


What are the aggregate and scalar functions?

493


What is the maximum row of a size?

548