Select top 1 * from (Select top n * from tbl order by column name asc)tbl

How to select nth record from a table?

Question Posted / saravanan p

Answer Posted / saravanan p

Select top 1 * from
(Select top n * from tbl order by column name asc)tbl1
order by column name desc

Is This Answer Correct ?

19 Yes

12 No

Please Help Members By Posting Answers For Below Questions

List out different types of normalizations in sql server and explain each of them?

975

How do I setup a local sql server database?

1070

How to reaname table name without using sp_Rename in sql server..?

1040

Explain what are various ways to enhance the ssrs report?

1097

what is the information that can be stored inside a bit column? : Sql server database administration

1010

How do I shrink an ldf file?

1039

What is perspective, have you ever created perspective? : sql server analysis services, ssas

962

What is the full form of dql?

1026

What is the use of RDBMS?

1055

How many databases Microsoft SQL server provides?

1155

Tell me what are the advantages of using stored procedures?

1062

What is a file group?

1166

How raid can influence database performance?

1087

What is normalization 1nf 2nf 3nf?

1109

Where are sql server usernames and passwords stored in the sql server?

1174