Sql/Nested.sql at main · surXcode/Sql · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
1.WAQTD 2ND MINIMUM SALARY


1.SELECT MIN(SAL)
FROM EMP
WHERE SAL >(SELECT MIN(SAL)
FROM EMP);

2.WAQTD 5TH MAXIMUM SALARY

2.SELECT MAX(SAL)
FROM EMP
WHERE SAL <(SELECT MAX(SAL)
FROM EMP
WHERE SAL <(SELECT MAX(SAL)
 FROM EMP
WHERE SAL <(SELECT MAX(SAL)
FROM EMP
WHERE SAL <(SELECT MAX(SAL)
FROM EMP))));

3.WAQTD NAME OF THE EMPLOYEE EARNING 3RD
MAXIMUM SALARY.

3.SELECT ENAME
FROM EMP
WHERE SAL=(SELECT MAX(SAL)
FROM EMP
  WHERE SAL <(SELECT MAX(SAL)
  FROM EMP
  WHERE SAL <(SELECT MAX(SAL)
  FROM EMP)));


4.WAQTD EMPNO OF THE EMPLOYEE EARNING 2D
MAXIMUM SALARY

4.SELECT EMPNO
 FROM EMP
 WHERE SAL=(SELECT MAX(SAL)
 FROM EMP
 WHERE SAL<(SELECT MAX(SAL)
 FROM EMP));

5.WAQTD DEPARTMENT NAME OF AN EMPLOYEE GETTING
4TH MAX SAL

5.SELECT DNAME
FROM DEPT
WHERE DEPTNO=(SELECT DEPTNO
FROM EMP
WHERE SAL=(SELECT MAX(SAL)
FROM EMP
WHERE SAL<(SELECT MAX(SAL)
FROM EMP
WHERE SAL<(SELECT MAX(SAL)
FROM EMP
WHERE SAL<(SELECT MAX(SAL)
FROM EMP)))));

6.WAQTD DETAILS OF THE EMPLOYEE WHO WAS HIRED 2nd

6. SELECT *
 FROM EMP
 WHERE HIREDATE=(SELECT MIN(HIREDATE)
 FROM EMP
 WHERE HIREDATE>(SELECT MIN(HIREDATE)
 FROM EMP));

7.WAQTD NAME OF THE EMPLOYEE HIRED BEFORE THE
LAST EMPLOYEE

7.SELECT ENAME
FROM EMP
WHERE HIREDATE>(SELECT MIN(HIREDATE)
FROM EMP);

8.WAQTD LOC OF THE EMPLOYEE WHO WAS HIRED FIRST.

8.SELECT LOC
 FROM DEPT
 WHERE DEPTNO = (SELECT DEPTNO
 FROM EMP
 WHERE HIREDATE=(SELECT MIN(HIREDATE)
 FROM EMP));

9.WAQTD DETAILS OF THE EMPLOYEE EARNING 7TH
MINIMUM SALARY.

9.SELECT *
 FROM EMP
 WHERE SAL=(SELECT MIN(SAL)
 FROM EMP
 WHERE SAL>(SELECT MIN(SAL)
 FROM EMP
 WHERE SAL>(SELECT MIN(SAL)
 FROM EMP
 WHERE SAL>(SELECT MIN(SAL)
 FROM EMP
 WHERE SAL>(SELECT MIN(SAL)
 FROM EMP
 WHERE SAL>(SELECT MIN(SAL)
 FROM EMP
 WHERE SAL>(SELECT MIN(SAL)
 FROM EMP)))))));

10.WAQTD DNAME OF EMPLOYEE GETTING 2ND MAXIMUM
SALARY

10.SELECT DNAME
  FROM DEPT
  WHERE DEPTNO IN (SELECT DEPTNO
 FROM EMP
 WHERE SAL=(SELECT MAX(SAL)
 FROM EMP
 WHERE SAL<(SELECT MAX(SAL)

 FROM EMP)));