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

What are all the common sql functions?

1031

---

What is sqlservr exe?

979

---

What are the types of queries in sql?

1086

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

980

---

Which one is better subquery or joins?

1062

---

What is flag in sql?

1036

---

How does a self join work?

1128

---

how to create a table index in mysql? : Sql dba

1061

---

Does sap use sql?

996

---

Is json a nosql?

982

---

What are sql functions? Describe in brief different types of sql functions?

1104

---

Which operator is used in query for pattern matching?

1089

---

Do we need to create index on primary key?

929

---

How many types of sql are there?

986

---

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1090

---