MySQL条件运算符的使用

条件运算符：>, <, 相等 =, 不等 <>, >=, <= 案例1：查询工资>12000的员工信息

USE myemployees;

SELECT
    *
FROM 
    employees
WHERE
    salary > 12000;

案例2：查询部门编号不等于90的员工名和部门编号

SELECT
    last_name AS 名字,
    department_id AS 部门编号
FROM 
    employees
WHERE
    `department_id` <> 90