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
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
Explain activity monitors
Write an SQL query to obtain the 2nd highest salary.
what's the maximum size of a row? : Sql server database administration
Explain candidate key, alternate key, and composite key?
Which trace flags are enabled in sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What is the recursive stored procedure in sql server?
We need to perform what steps in the following order to work with a cursor?
How do I know if localdb is running?
What are various aggregate functions that are available?
What are the two modes of authentication in sql server?
What is a result set object returned by odbc_exec()?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
How to perform backup for certificates in sql server? : sql server security