SELECT TOP 1 ID FROM TABLENAME WHERE ID NOT IN (SELECT TOP 1 ID FROM TEST)

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

Question Posted / vardharaj

Answer Posted / vardharaj

SELECT TOP 1 ID FROM TABLENAME WHERE ID NOT IN (SELECT TOP 1
ID FROM TEST)

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is BCP? When does it used in sql server 2012?

576

Explain the microsoft sql server delete command?

526

Should you normalize audio?

521

What are distributed partitioned views?

612

Define outer join?

527

What are indexes in ms sql server?

543

Benefits of Stored Procedures?

557

What are the instances when triggers are appropriate?

518

List few advantages of stored procedure.

529

Define primary key?

655

What is raid, and how it can influence database performance?

568

What are the types of joins in sql?

551

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

631

Explain what is lock escalation and what is its purpose?

508

Does partitioning ssd reduce performance?

483