write query for fourth maximum salary from employee table
- 14 Answers
- 21984 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
Answer Posted / dharmendra k. dixit
For Finding Nth Salary...
SELECT TOP 1 Salary FROM
(SELECT TOP nth Salary FROM Table Order by Salary Desc)Table
As Sal Order by Salary
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
What is rank function?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is an indexing technique?
Explain what are magic tables in sql server?
Can you create a logon trigger in sql server 2005 express edition?
What is the osql utility?
Does full backup break log chain?
What is filestream?
Why truncate is ddl command?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How to send a ssrs report from ssis?
How to change parameter value inside the report?
Explain system rowset functions?
What the different components of Replication and what is their use?
What are the differences between triggers and stored procedures?
