Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 40910 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
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
How optimize sql query with multiple joins in sql server?
What is a self join in sql server?
What is the difference between ddl,dml and dcl commands?
What is model database? : SQL Server Architecture
What is the most common trace flags used with sql server?
What is a virtual table in sql?
Explain having clause and where clause?
What are exact numeric data types in ms sql server?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Can you explain the disadvantages/limitation of the cursor?
What is sql injection and why is it a problem? : sql server security
Why should one not prefix user stored procedures with ‘sp_’?
What is the main difference between ‘between’ and ‘in’ condition operators?
