Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 40816 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 trigger explain with program?
What is transact-sql ddl trigger?
what is the difference between openrowset and openquery?
How to replace given values with null using nullif()?
How adventureworkslt tables are related?
Explain what is cte (common table expression)?
State the difference between local and global temporary tables?
How to edit table in sql server 2017?
What are the pre-defined functions in the sql server?
Explain the categories of stored procedure?
What happens if null values are involved in arithmetic operations?
What are the reporting services components?
What are the new features of sql server 2008 r2 reporting service?
can an order by clause be used in a creation of a view?
Describe in brief system database.
