Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 40368 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
Why main is user defined function?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What are different types of database indexes?
Explain the difference between delete,drop and truncate in SQL Server?
What is the order by used for?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is sql server transaction log file?
How to provide login information for a new odbc dsn?
Explain the architecture of ms sql reporting service?
How to drop an existing table?
Explain what role entity and relationship play in an ER diagram.
What are the different types of replication are there in sql server 2000?
What is table constraint?
Do you know what is sql service broker?
