Answer Posted / neetika vardhan

SELECT DEPT, MAX(SAL)
FROM EMP
WHERE SAL NOT IN (SELECT MAX(SAL) FROM EMP GROUP BY DEPT)
GROUP BY DEPT

UNION

SELECT DEPT, MAX(SAL)
FROM EMP
GROUP BY DEPT

UNION

SELECT DEPT, MAX(SAL)
FROM EMP
WHERE SAL NOT IN
(SELECT MAX(SAL)
FROM EMP
WHERE SAL NOT IN (SELECT MAX(SAL) FROM EMP GROUP
BY DEPT)
GROUP BY DEPT

UNION

SELECT MAX(SAL) FROM EMP GROUP BY DEPT)
GROUP BY DEPT

how to select unique records from a table? : Sql dba

636

---

Can instead of triggers be used to fire once for each statement on a view?

541

---

How many row comparison operators are used while working with a subquery?

539

---

What is rowid in sql?

512

---

What is dbo in sql?

536

---

---

How to run sql statements with oracle sql developer?

625

---

How do you write a subquery?

524

---

Is sql a scripting language?

521

---

Is pl sql different from sql?

536

---

How do I start sql from command line?

537

---

What are the types of optimization?

521

---

how to shutdown mysql server? : Sql dba

570

---

Is postgresql a server?

577

---

How does rowid help in running a query faster?

970

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

669

---