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

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

When to use null data driven subscription?

148


How to scale out a federation by Sql statement?

92


What is a system database and what is a user database?

581


What are a database and a data warehouse?

570


What is enhanced database mirroring in sql server 2008?

516






While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

621


What is difference between Datepart() and Datename() in SqlServer?

719


What is temporary stored procedure?

548


What it means to be triggered?

502


How to Check if table exists in sql server?

618


optimization techinques

2196


Can sql servers link to other servers?

565


What is a cache in ssrs?

110


What is a DBMS, query, SQL?

575


What are diverse clauses that form a part of sql?

599