select top 1 * from(select top 2 * from tbl_test order by 1 asc) as at or

how to retrive only second row from table in sql server
2000?

Question Posted / lekhraj

Answer Posted / lekhraj

select top 1 * from(select top 2 * from tbl_test order by 1
asc) as at order by 1 desc

Is This Answer Correct ?

24 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Define magic tables in sql server?

1070

What is scrollable cursor?

1044

What is database replication? What are the different types of replication you can set up in sql server?

964

What is the maximum row of a size?

1020

What is #temp and @table variable in SQL server?

1096

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1016

How does recursive cte works in sql server?

1019

Tell me what is the significance of null value and why should we avoid permitting null values?

993

How to create a local temporary stored procedure?

999

How to stop log file growing too big?

1019

Do you know what are the reporting services components?

978

Tell me the phases a transaction has to undergo?

965

What are the general features of sql server management studio? : sql server management studio

1087

Define inner join in sql server joins?

1064

What is encryption key?

132