select top 1 * from (select top 2 * from employee)A

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

Question Posted / madhuparna

Answer Posted / madhuparna

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between NOROW and LOCKROW?

2827

What is the difference between lock, block and deadlock? : sql server database administration

1036

What are the system database in sql server 2005?

1038

How to list all tables in the database using odbc_tables()?

1038

Define magic tables in sql server?

1047

What is the dbcc command and why is it used?

1044

What are ddl (data definition language) statements for tables in ms sql server?

1095

Which is the main third-party tool used in sql server?

932

What are the characteristics of modern DBMS?

1082

What is intellisense?

1044

How are the exceptions handled in sql server programming?

1058

Why functions are used in sql server?

953

What are the different types of cursor?

1087

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1133

What is log cache in sql server?

1030