How to select nth record from a table?
Answer Posted / soorai ganesh
SELECT * FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY column_name) AS Rno,*
FROM Table_Name
)T
WHERE T.Rno = 7 -- If N is 7 other wise put ur nth value.
Is This Answer Correct ? | 45 Yes | 9 No |
Post New Answer View All Answers
Explain boyce and codd normal form(bcnf)?
What command must you use to include the not null constraint after a table has already been created?
What is TDS(Tabular Data Stream) Gateway?
What is relationship? What number of sorts of relationship are there?
How do I view a stored procedure in sql server query?
What are the advantages of partitioning?
which table keeps the locking information? : Sql server administration
Explain throw statement in sql server 2008?
what are the core components of SSRS?
How to connect sql server management studio express to sql server 2005 express?
What is snapshot report?
Explain the usage of floor function in sql server.
Explain how to send email from sql database?
What is mapping schema?
When would you use sql joins?