how to retrive only second row from table in sql server
2000?
- 15 Answers
- 23200 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
Can we install sql server 2016 on windows 7?
List out some of the requirements to set up a sql server failover cluster?
Can you please differentiate between a primary key and a unique key?
What is the sql server agent?
How you can find out if an index is useful to the optimizer?
What is use of @@ spid in sql server?
What is an index in sql?
where can you add custom error messages to sql server? : Sql server administration
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
How to convert character strings into numeric values?
What is the purpose of sql profiler in sql server? : sql server database administration
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
What is xdr?
In what three ways is the return statement used in a stored procedure?
Difference between DELETE and TRUNCATE?
