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

Can we perform dml on view?

1118

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4061

---

What is faster join or subquery?

1068

---

How to run sql*plus commands in sql developer?

1206

---

Can %notfound return null after a fetch?

1104

---

Why do we use function in pl sql?

1114

---

What does pl sql stand for?

1156

---

how can we destroy the cookie? : Sql dba

1082

---

Is ms sql traffic encrypted?

962

---

What is data types in sql?

1070

---

What is java sql drivermanager?

1161

---

Can ddl statements be used in pl/sql?

1193

---

What are conditional predicates?

1128

---

What is vector point function?

1096

---

Explain character-manipulation functions?

1176

---