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
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What is normalization and denormalization in sql server?
What are 3 ways to get a count of the number of records in a table?
What is the purpose of floor function?
Explain external key management in sql server 2008
How to connect a database with sql express.?
Explain rdbms?
How to create indexed view?
Which trace flags are enabled in sql server?
When columns are added to existing tables, what do they initially contain?
Can binary strings be used in arithmetical operations?
Can I run multiple instances of sql server 2000 at the same time on one computer?
How efficient you are in oracle and SQL server?
What are the lambda triggers?