1
2
3
4
5
6
7
8
9
10
| select * from employee where age in (20,21,22,23)and gender='女';
select * from employee where gender='男' and age between 20 and 40 and name like '___';
select gender, count(*) from employee where age<60 group by gender;
select * from employee where age<=35 order by age asc ,enterday desc ;
select name from employee where gender='男' and age between 20 and 40 order by age ,enterday desc limit 5;
|
