select top 1 * from xyz where rno > (select top 1 rno from xyz) rno i

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

Question Posted / prabhat sharma

Answer Posted / prabhat sharma

select top 1 * from xyz where rno > (select top 1 rno from xyz)

rno is a column name and xyz is a table name

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How will you find out if there are expensive SQL statements running or not?

1007

What is view in sql?

894

What is a database table?

961

What is set nocount on?

932

What is normalization? What number of normalization shapes are there?

1095

What are the requirements to use odbc connections in php scripts?

1104

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

998

What are the properties of the transactions?

1109

What are the disadvantages of using querystrings to send data from one page to another?

990

Other than truncate statement, which other command can by-pass the trigger on the tables?

1120

what are the three command line utilities and what are their primary functions?

144

Explain why variables called the most powerful component of ssis?

1079

What gets stored inside msdb database?

1240

What is the maximum rows in sql server table?

904

Define model database?

964