数据库条件查询

 

----条件查询----

1、查询年龄大于20岁的学员信息

Select * from stu where age >20;

2、查询年龄大于等于20岁的学员信息

Select * from stu where age >= 20;

3、查询年龄大于等于20岁·，并且年龄小于等于30岁的学员信息

Select * from stu where age >= 20 && age <= 30;

Select * from stu where age >= 20 and age <=30;

Select * from stu where age BETWEEN 20 and 30;

4、查询入学日期在1998-09-01到1999-09-01之间的学员信息

Select * from stu where hire_date Between ‘1998-09-01’ and ‘1999-09-01’;

5、查询年龄等于18岁的学员信息

Select * from stu where age = 18;

6、查询年龄不等于18岁的学员的信息

Select * from stu where age !=18;

Select * from stu where age <>18;

7、查询年龄等于18岁或者年龄等于20岁或者年龄等于22岁的学员信息

Select * from stu where age = 18 or age =20 or age=22;

Select * from stu where age in (18,20,22);

8、查询英语成绩为null的学员信息

注意：null值的比较不能使用=  !=   需要使用 is   is not

Select * from stu where english is null;

Select * from stu where english is not null