Hi, select top 1 * from (SELECT TOP 2 * from emp) A Order by empno des

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

Question Posted / suresh

Answer Posted / suresh

Hi,

select top 1 * from (SELECT TOP 2 * from emp) A Order by
empno desc

Is This Answer Correct ?

16 Yes

9 No

Please Help Members By Posting Answers For Below Questions

what's the difference between a primary key and a unique key? : Sql server database administration

894

Can sql servers link to other servers like oracle?

795

what information is maintained within the msdb database? : Sql server administration

915

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

894

What is a trigger what are the advantages of trigger?

917

How do I find the size of a sql server database?

879

What is buffer cash and log cache in sql server?

1056

What is difference between inner join and join?

986

How to connect to SQL Azure Database by using sqlcmd?

136

Tell me what are the advantages of using stored procedures?

949

Write a sql query to get zero records from a table having n number of records?

1131

What is forward - only cursors / read only cursor?

1023

What is standby servers? Explain types of standby servers.

931

What is it unwise to create wide clustered index keys?

957

Is sql server difficult to learn?

867