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 to disable triggers using "disable trigger"?

549

Explain what are commit and rollback in sql?

520

What is the fillfactor concept in indexes?

524

What is difference between rownum and rowid?

501

How to download microsoft sql server 2005 express edition?

567

Explain the Ways to improve the performance of a sql azure database?

How many types of triggers are there?

564

Can we shrink data file in sql server?

529

Define outer join in sql server joins?

515

What are the recovery models for a database?

609

What is an index in sql?

542

How to disable a login name in ms sql server?

581

What are the restrictions applicable while creating views? : SQL Server Architecture

579

Do you know what is sql service broker?

525

Explain what are sparse columns?

559