Interested to Buy Any Domain ? << Click Here >> for more details...
Query for second maximum salary in each in each department
- 15 Answers
- 38367 Views
- DST Global Solutions, TCS, I also Faced
- E-Mail Answers
Answer Posted / nancy singhal
select max(salary) from emp where salary in(select salary
from emp where salary not in(select max(salary) from emp));
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is the difference between between and in condition operators?
How is debugging done?
How do I view a view in sql?
What is difference between sql and mysql?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What jobs use sql?
Explain polymorphism in pl/sql.
How to process query result in pl/sql?
How can we optimize a sql query?
Does sql*plus have a pl/sql engine?
Is hadoop a nosql?
What is the trigger in sql?
What is trigger and stored procedure in sql?
