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 etl - extraction, transformation, and loading?

919

Define the one-to-one relationship while designing tables.

903

What’s the use of custom fields in report?

944

What is normalization process?

1181

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1091

What new changes are being made in SQL Server?

1188

Difference between report and query parameter.

1100

How self join is different from outer join?

1121

Does order by actually change the order of the data in the tables or does it just change the output?

1147

Can we call future method from queueable?

1052

How to use values from other tables in update statements in ms sql server?

1118

how would you store your query in an SSRS report or a Database server?

162

What is meant by indexing?

1022

How to configure odbc dsn with different port numbers?

1089

What is implicit mode in sql server?

1106