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 a schema in sql server 2005? : Sql server database administration

1037

Explain primary key, foreign key and unique key?

1000

What is an indexed view?

973

What is normalization and denormalization in sql server?

1024

How many types of keys are there?

1043

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

1057

What are constraints?

1019

Define a cross join?

1042

What is trigger in salesforce?

991

How can we solve concurrency problems?

1064

What is difference between commit and rollback when used in transactions?

973

What are the system database in sql server 2005?

1053

What is transaction server explicit transaction?

1045

How to create database with physical files specified in ms sql server?

1007

What number aggregate functions are accessible there in sql?

1085