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 is sub-query in sql server?

659

How to stop log file growing too big?

566

What do you mean by an execution plan? Why is it used? How would you view it?

525

What is difference between temp table and cte?

526

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

746

Define a cross join?

585

How do we know if any query is retrieving a large amount of data or very little data?

546

Where to find ntwdblib.dll version 2000.80.194.0?

546

Do you know what is normalization of database? What are its benefits?

552

What is t-sql script to take database offline – take database online.

596

What is database architecture? : SQL Server Architecture

541

What is rank function?

599

Are null values the same as that of zero or a blank space?

567

How check triggers in sql server?

512

How to declare and use cursor variables?

576