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 extended events?

1009

Explain database normalization?

1234

What are the encryption mechanisms in sql server?

1033

Can We Use Data-grids For Our Report In Ssrs?

185

what are database files and filegroups? : Sql server database administration

952

Write the syntax for stuff function in an sql server?

1032

Which is better statement or preparedstatement?

935

plss anybody specify tha constrian management system in dbms

2155

How do I install only the client tools of sql server 2000?

1072

How to enable tcp/ip protocol on a sql server?

1171

What are different types of join?

1321

What is difference between group by and having?

947

What does set rowcount do?

913

What is a view in sql?

979

What is an sql server agent?

1072