Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 40862 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
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
Define full outer join?
How many databases Microsoft SQL server provides?
What is a collation in ms sql server?
What is the difference between char, varchar and nvarchar?
How to list all objects in a given schema?
What is the recovery model?
How to use “drop” keyword in sql server and give an example?
Benefits of Stored Procedures?
What is nested transaction?
What are the diifferences between the ms sql server vs mysql?
How to test a dml trigger in ms sql server?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
Why Master database is required?
How much space does sql server 2016 take?
