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 >9000and salary <=20000;
OR
select employee_name,dep_name from employee where dep_id =1or dep_id =3;
NOT
select employee_name from employee wherenot(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 between5000and10000)and(dep_name notin('销售','苍盐海'));
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
selectdistinct dep_id from employee orderby dep_id desc;selectdistinct dep_id from employee orderby dep_id;
LIMIT
select dep_id from employee orderby dep_id limit2;selectdistinct dep_id from employee orderby dep_id limit2;select*from employee where dep_name ='苍盐海'orderby salary desclimit1;