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

15 Answers
26171 Views
Cognizant, CTS, I also Faced
E-Mail Answers

Answer Posted / yogesh

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

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

whats new about truncate in sql server 2008?

2440

How to change server name in sql server?

1098

What is 3nf normalization form?

1024

What are Row versions of DataRow?

974

List out some of the requirements to set up a sql server failover cluster?

979

What is difference between index seek vs. Index scan?

1096

What are the purposes of floor and sign functions?

924

How to get the definition of a trigger back?

958

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1021

How you can get a list of all the table constraints in a database? : Sql server administration

948

What is the synonym of join?

895

List all types of constraints in sql server?

961

Can I work with several databases simultaneously? : sql server management studio

943

How to select all columns of all rows from a table with a select statement in ms sql server?

1045

What is sql or structured query language?

1086