sql入门--运算符、排序

select employee_name,salary from employee where salary < 10000;
select employee_name,salary from employee where salary >= 10000;

AND

select employee_name,salary from employee where salary > 9000 and salary <= 20000;

OR

select employee_name,dep_name from employee where dep_id = 1 or dep_id = 3;

NOT

select employee_name from employee where not (dep_name != '苍盐海' and salary < 10000);

IN

-- in中的值必须为已经存在的值，例如按时间查询，并不是查询出两个时间段内的值。in只是做多条件查询而已。
select employee_name,dep_id from employee where dep_name in ('苍盐海','息山');
select employee_name,dep_name from employee where enter_time in ('2018-01-01','2022-08-02');

BETWEEN AND

-- between and 包含边界值
select employee_name from employee where (salary between 5000 and 10000) and (dep_name not in ('销售','苍盐海'));

LIKE模糊查询

-- 水开头
select employee_name,dep_name from employee where dep_name like '水%';
-- 付结尾
select employee_name,dep_name from employee where dep_name like '%付';
-- 含盐的数据
select employee_name,dep_name from employee where dep_name like '%盐%';
-- _表示一个字符
select employee_name,dep_name from employee where dep_name like '%付____';

ORDER BY

select distinct dep_id from employee order by dep_id desc ;
select distinct dep_id from employee order by dep_id;

LIMIT

select dep_id from employee order by dep_id limit 2;
select distinct dep_id from employee order by dep_id limit 2;
select * from employee where dep_name = '苍盐海' order by salary desc limit 1;