How to select nth record from a table?
Answer Posted / pallavi attarde
Here N is for Nth record.
SELECT TOP 1 * FROM
(SELECT TOP N * FROM
(SELECT Table.Coloumn1,Table.Coloumn2 from Table)
as d order by d.Coloumn1 desc) as p order by Coloumn1
Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
What are the benefits and tasks of object explorer? : sql server management studio
List the ways in which dynamic sql can be executed?
Where the sql logs gets stored?
Explain about local stored procedure?
what are the different ways to return the rowcount of a table?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Do you know what is replace and stuff function in sql server?
what is spatial nonclustered index
How to create a view on an existing table in ms sql server?
What is the library index called?
What is the partitioning method?
What does asynchronous call backs means?
How can you append an identity column to a temporary table?
How do I find query history in sql server?