select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal.
Answer Posted / jey ganesh
select min(sal) from employee where sal in(
select top 3 sal from employee order by sal desc)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is built-in/administrator?
How to execute a stored procedure in ms sql server?
Do you know concepts and capabilities of sql server?
How to skip remaining statements in a loop block using continue statements?
Tell me when is the update_statistics command used?
What are the requirements to use odbc connections in php scripts?
How to update multiple rows with one update statement in ms sql server?
What is snapshot parameter in ssrs?
What is set nocount on?
What is an index in a database?
How to delete duplicate records based on single column from a table?
What are the types of indexing?
What is the need for indexing?
How to move database physical files in ms sql server?
List out different types of normalizations in sql server and explain each of them?