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 ? | 19 Yes | 12 No |
Post New Answer View All Answers
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What are “unrepeatable reads”?
What is SubQuery in SQL Server 2008
What is a file group?
What is sql profiler. What are the default templates with it? : sql server database administration
what is isolation level at dead lock?
How do I find query history in sql server?
What does the on update no action do?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
What are the differences between char and varchar in ms sql server?
How would you choose between a clustered and a non-clustered index?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What is the difference between cartesian product and cross join?
What are date and time data types in ms sql server?
What are sql azure firewall rules?