write query for fourth maximum salary from employee table
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 difference between inner join and join?
What are functions in the sql server?
Tell me about normalization in DBMS.
What is the partitioning method?
How do you make a trace?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
How to see existing views in ms sql server?
Explain sql server service broker?
What is a result set object returned by mssql_query()?
What is conditional split?
What are the two modes of authentication in sql server?
What is autocommit mode in sql server?
How many joins in sql server?
What is the difference between a clustered index and a non-clustered index?
What is the difference between mysql and mysqli?