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

Can you use order by when defining a view?

968

What are different types of statements that are supported by sql?

1033

What is the main purpose of having conversation group?

894

What is outer join in sql server joins?

1110

How to create new tables with "select ... Into" statements in ms sql server?

983

Explain about integration services of Microsoft SQL server?

1029

What is rtm version in sql server?

1040

What do you understand by coalesce in sql server?

1062

Explain stored procedure?

1045

Explain the difference between clustered and non-clustered index?

919

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

936

Explain about unique identifier data type in sql server?

905

What are various limitations of the views?

1049

What is the default fill factor value?

1073

What are the types of indexes?

1074