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
What is the recursive stored procedure in sql server?
Are resultset updatable?
Why main is user defined function?
What are filegroups in sql server?
What is amo? : sql server analysis services, ssas
Can you get second highest salary from the table?
Can a database be shrunk to 0 bytes, if not, why?
How can you fetch alternate records from a table?
Explain what are magic tables in sql server?
Explain error handling in ssis?
What is a select query statement in ms sql server?
What number sorts of privileges are accessible in sql?
Determine when to use stored procedure to complete sql server tasks?
What is auditing in sql server?
What is extended stored procedures?