MySQL数据库基础学习（十七）

select * from emp where gender = '女' and age in(20,21,22,23);

select * from emp where gender = '男' and ( age between 20 and 40 ) and name like
'___';

select gender, count(*) from emp where age < 60 group by gender;

select name , age from emp where age <= 35 order by age asc , entrydate desc;

select * from emp where gender = '男' and age between 20 and 40 order by age asc ,
entrydate asc limit 5 ;