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

Mention the differences between local and global temporary tables.

1023

How many servers can we create in a single subscription?

160

What is an example of a primary key?

974

What is policy management?

990

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2003

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1253

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

997

What type of locking occurs during the snapshot generation? : sql server replication

1328

What is self join in sql server joins?

1051

What is meant by datasource?

917

How do I perform an unattended install of sql server 2000?

1078

can an order by clause be used in a creation of a view?

1167

What is ddl and dml commands?

899

Which is better statement or preparedstatement?

920

Does group by or order by come first?

952