select top 1 * from(select top 3 * from tablename order by 1 asc) as at or

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

Question Posted / surenda tarai

Answer Posted / surenda tarai

select top 1 * from(select top 3 * from tablename order by 1
asc) as at order by 1 desc

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is filestream?

1007

Explain what is cte (common table expression)?

1136

Explain the commands in sql server?

1043

What is the federation in sql azure?

what is raid and what are different types of raid configurations? : Sql server database administration

1050

What is a natural primary key?

1054

What is the temp table?

929

How many triggers you can have on a table?

1000

What is the report model project?

142

What type of locking occurs during the snapshot generation? : sql server replication

1338

What does top operator do?

1028

What is user defined datatypes and when you should go for them?

1019

What are the drawbacks of reporting in ssrs?

151

Where is my database stored on the hard disk in ms sql server?

1066

How do you check sql server is up and running?

1006