Chọn mức lương cao nhất trong MySQL

Sử dụng hàm MAX(). Cú pháp:

SELECT MAX(tenCot) AS tenBietDanh FROM tenBang;

Tạo bảng demo44:

mysql> CREATE TABLE demo44 (
    -> employee_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    -> employee_name VARCHAR(20),
    -> employee_salary INT
    -> );

Chèn dữ liệu:

mysql> INSERT INTO demo44(employee_name, employee_salary) VALUES('John',3000);
mysql> INSERT INTO demo44(employee_name, employee_salary) VALUES('David',4500);
mysql> INSERT INTO demo44(employee_name, employee_salary) VALUES('Bob',3500);
mysql> INSERT INTO demo44(employee_name, employee_salary) VALUES('Carol',5500);
mysql> INSERT INTO demo44(employee_name, employee_salary) VALUES('Mike',4900);

Hiển thị dữ liệu:

mysql> SELECT * FROM demo44;

Kết quả:

+-------------+---------------+-----------------+
| employee_id | employee_name | employee_salary |
+-------------+---------------+-----------------+
| 1           | John          | 3000            |
| 2           | David         | 4500            |
| 3           | Bob           | 3500            |
| 4           | Carol         | 5500            |
| 5           | Mike          | 4900            |
+-------------+---------------+-----------------+

Truy vấn lấy lương cao nhất:

mysql> SELECT MAX(employee_salary) AS Highest_Salary FROM demo44;

Kết quả:

+----------------+
| Highest_Salary |
+----------------+
| 5500           |
+----------------+