select top 2 from tablename

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

Question Posted / ravi

Answer Posted / ravi

Is This Answer Correct ?

6 Yes

28 No

Please Help Members By Posting Answers For Below Questions

What is the difference between delete and truncate statements?

1020

What are scalar functions?

949

Tell me the phases a transaction has to undergo?

917

How sql server executes a statement with nested subqueries?

962

Explain what is sql server english query?

988

How to write an inner join with the where clause in ms sql server?

1034

What is master database? : SQL Server Architecture

952

Tell me what is a linked server?

989

What is report snapshot?

142

What is function of ROLLUP ?

1041

Are resultset updatable?

895

What is the cartesian product of the table?

902

What is query optimizer in sql server?

959

How to delete a login name in ms sql server?

1005

How to retrieve error messages using mssql_get_last_message()?

994