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
How to disconnect from a sql server using mssql_close()?
Explain following error properties?
How to disable triggers using "disable trigger"?
What is the importance of three tier architecture?
What options are available to audit login activity? : sql server security
How to insert data with null values?
How extra digits are handled with numeric data type literals?
How to set a database state to offline in ms sql server?
What is mssql?
what authentication modes does sql server support? : Sql server database administration
When is update_statistics command used?
Explain about Views?
Mention the differences between substr and charindex in sql server.
What is de-normalization and what are some of the examples of it?
What is the difference between a check constraint and a rule?