GIven the following Employee relational database
|
ID |
First Name |
Salary |
|
1 |
Ben |
8000 |
|
2 |
Joe |
4000 |
|
3 |
Mark |
7000 |
|
4 |
Steve |
3000 |
|
5 |
John |
7000 |
What does the following expression result
Select MAX(Salary)
from Employee
where Salary < ( Select MAX(Salary) from Employee)
1
3000
2
4000
3
7000
4
8000