how to retrive only second row from table in sql server
2000?
Answer Posted / ramana
Table Like this
Create Table Employee(Name varchar(20),Location
varchar(20),Salary int)
Query Like this
Select top 1 * from employee where Name not in(select top 1
Name from Employee)
it will display second record....
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Name three of the features managed by the surface area configuration tool? : sql server security
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Can a cursor be updated? If yes, how you can protect which columns are updated?
How to use union to merge outputs from two queries together in ms sql server?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
What is a fan-out query in SQL Azure?
What are views used for?
what is the difference between openrowset and openquery?
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?
Explain about nested stored procedure?
What is a trigger and its types?
Why do we backup Active Directory ?
What do you understand by recursive stored procedure?