How to select nth record from a table?
Answer Posted / roxy
select top 1 * from (select top n * from tbl order by col1
desc) tbl order by col1 asc
where n = nth number in the list
Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
Is foreign key a primary key?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Can you explain what are commit and rollback in sql?
What do you need to connect php to sql server?
What are rows and columns?
What is filtered index?
Why would you call update statistics?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
How to list all login names on the ms sql server?
What is a collation?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
How to modify an existing stored procedure in ms sql server?
How you provide security to cube? : sql server analysis services, ssas
How many types of stored procedures are there in sql server?
What is truncate table?