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
When to use null data driven subscription?
How to scale out a federation by Sql statement?
What is a system database and what is a user database?
What are a database and a data warehouse?
What is enhanced database mirroring in sql server 2008?
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?
What is difference between Datepart() and Datename() in SqlServer?
What is temporary stored procedure?
What it means to be triggered?
How to Check if table exists in sql server?
optimization techinques
Can sql servers link to other servers?
What is a cache in ssrs?
What is a DBMS, query, SQL?
What are diverse clauses that form a part of sql?