Javaweb-DQL-条件查询

1. select * from stu where age>20;
2. select * from stu where age>=20;
3. select * from stu where age>=20 and age<=30;
4. select * from stu where hire_date BETWEEN '1998-09-01' and '1999-09-01';
5. select * from stu where age=18;
6. select * from stu where age<=18;
7. select * from stu where age in(18,20,22);
8. select * from stu where english is null;

1. select * from stu where name like '马%';
2. select * from stu where name like '_花%';
3. select * from stu where name like '%德%';