Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 40775 Views
- DELL, Microsoft, Ramco, I also Faced
- E-Mail Answers
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 is the difference between functions and stored procedures?
What are rows and columns?
What Is Rdbms?
State the difference between union and union all?
How global temporary tables are represented and its scope?
What are synonyms?
How do I start and stop sql server?
Are null values the same as that of zero or a blank space?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is store procedure?
What are triggers? How do you invoke a trigger on demand?
What is nolock hint in sql server 2008
When a primary key constraint is included in a table, what other constraints does this imply?
How to create a simple user defined function in ms sql server?
What is normalization according to you and explain its different levels?
