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

What number aggregate functions are accessible there in sql?

1078

What are different types of table joins?

1019

What is log cache in sql server?

1051

How ssrs maintain security?

1091

What's the information that can be stored inside a bit column?

1009

What does select 1 mean?

937

What is bookmark link in ssrs?

245

List down some advantages of sql stored procedure?

970

What is the use of “join” in sql server?

1105

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

988

How to configure odbc dsn with different port numbers?

1090

How dts is used to extract, transform and consolidate data?

1076

Explain features and concepts of analysis services?

983

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1054

How will you hide an attribute? : sql server analysis services, ssas

964