Code: Select all
+---------+----------+
| Name | Salary |
+---------+----------+
| John | 100 |
| Marry | 200 |
| Petter | 300 |
| Lynn | 400 |
+---------+----------+
Code: Select all
SELECT name, MAX(salary) as salary FROM employee;
Code: Select all
SELECT
name,
MAX(salary) AS salary
FROM
employee
WHERE
salary < (SELECT MAX(salary) FROM employee);
Code: Select all
SELECT
name,
MAX(salary)
FROM
employee
WHERE
salary NOT IN ( SELECT Max(salary) FROM employee);
Code: Select all
SELECT
name,
MAX(salary) AS salary
FROM
employee
WHERE
salary IN (SELECT salary FROM employee MINUS SELECT MAX(salary) FROM employee);