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

What does the update command do?

1050

What is the difference between a check constraint and a rule?

1131

what is the difference between delete table and truncate table commands? : Sql server database administration

963

How to add the custom code in Report?

117

What is simple indexing method?

969

What is PROJECTION Operation?

960

What is a bit datatype?

923

What is SQL Azure Data sync?

119

What are different replication agents and what's their purpose? : sql server replication

958

What is report subscription?

117

Do you know what is openxml in sql server?

1015

What are the steps to take to improve performance of a poor performing query? : sql server database administration

978

What are the steps to follow to configure SQL*Net?

991

How to get the definition of a user defined function back?

999

What is measure group, measure? : sql server analysis services, ssas

960