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

15 Answers
23222 Views
Cognizant, CTS, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

116

How to replace the Query Result 'Null Value' with a text ?

673

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

574

What is primary key index?

630

What is user-defined function?

664

What is use of except clause? How does it differ from not in clause?

640

What is triggers and its types?

631

Can you pass expressions to stored procedure parameters?

589

What are the results of running this script?

601

What is use of except clause? How it differs from not in clause?

690

What is 1nf 2nf?

657

how to avoid cursors? : Sql server database administration

574

List out what other servers you can use with ssrs?

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1523

What is the use of nvl work?

657