SQL一一DQL一一条件查询

语法：

        select 字段列表 from   表名 where 条件列表；

列题：

给出下面的表，有七小题：

①查询年龄等于88的员工：

SELECT id,workno,NAME,gender,age,idcard,place FROM emp WHERE age=88;

②查询没有身份证号的员工信息：

SELECT id,workno,NAME,gender,age,idcard,place FROM emp WHERE idcard is null;

③查询有身份证号的员工信息：

SELECT id,workno,NAME,gender,age,idcard,place FROM emp WHERE idcard IS  not NULL;

④查询年龄在15岁（包含）到20岁（包含）之间的员工信息：(有三种写法)

select id,workno,name,gender,age,idcard,place from emp where age>=15 && age<=20;
SELECT id,workno,NAME,gender,age,idcard,place FROM emp WHERE age>=15 and age<=20;
SELECT id,workno,NAME,gender,age,idcard,place FROM emp WHERE age between 15 and 20;
//注意：between后面加最小值and后面加最大值

⑤ 查询性别为女且年龄小于20的

SELECT id,workno,NAME,gender,age,idcard,place FROM emp WHERE gender='女' AND age<=20;
 

⑥查询姓名为三个字的员工：

SELECT id,workno,NAME,gender,age,idcard,place FROM emp WHERE NAME LIKE'_ _ _';

⑦查询身份证号最后一位是2的员工：

SELECT id,workno,NAME,gender,age,idcard,place FROM emp WHERE idcard LIKE'%2';
SELECT id,workno,NAME,gender,age,idcard,place FROM emp WHERE idcard LIKE'_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 2';