select min(id) from cms_dfm where id in (SELECT TOP 2 ID from CMS

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

Question Posted / shashikant

Answer Posted / shashikant

select min(id) from cms_dfm where id in (SELECT TOP 2 ID
from CMS_DFM Order by
ID desc)

Is This Answer Correct ?

6 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How you can change the database name in SQL SERVER?

1199

What is a trigger and types of a trigger?

984

How to enforce security in sql server? : sql server security

1113

How to create a simple stored procedure in ms sql server?

1035

What is replication with database mirroring? : sql server database administration

1083

How to connect php with different port numbers?

1091

Tell me what is the difference between locking and multi-versioning?

1036

How to loop through result set objects using mssql_fetch_array()?

1087

what is the maximum size of a row? : Sql server database administration

1020

How do I perform an unattended install of sql server 2000?

1087

What are the types of stored procedures in an sql server?

993

How many joins in sql server?

965

What is similarity and difference between truncate and delete in sql?

1104

What is pivot and unpivot?

1016

Differentiate between a local and a global temporary table?

962