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
What is the default Port No on which SQL Server listens?
Determine when to use stored procedure to complete sql server tasks?
Can we use where clause with group by?
How to declare and use cursor variables?
How do you delete a trigger?
How to assign null values to variables or columns?
Why use cursor in sql server?
How to update values in a table with update statements in ms sql server?
How can I check that whether automatic statistic update is enabled or not?
Explain the architecture of ms sql reporting service?
Why I have to use stored procedures?
How to make conditional sum in ssrs?
Tell me extended events in sql server 2008?
What are the aggregate and scalar functions?
What is the maximum row of a size?