select top 1 from tablename where id <(select top 1 id from test)

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

Question Posted / yogesh

Answer Posted / yogesh

select top 1 from tablename where id <(select top 1 id from
test)

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the advantages dts has over bcp?

532

What is default constraint?

543

How to declare and use cursor variables?

585

How can windows applications connect to sql servers via odbc?

585

How to delete all rows with truncate table statement in ms sql server?

492

What is the difference between dbcc indexdefrag and dbcc reindex?

523

How to add an address record into adventureworkslt?

570

What are the default system databases in sql server 2000?

538

What are the differences between triggers and stored procedures?

534

What is policy management?

580

What specific conditions database should meet, before you can bulk copy data into it using bcp?

536

What is the use of toad or sqldbx.?

722

What is a rollup clause?

547

What is co-related sub query?

565

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1632