-- 1.查询年龄大于88的员工
SELECT * FROM emp where age = 80;
-- 2.查询年龄小于20岁的员工信息
SELECT * FROM emp where age < 20;
-- 3.查询年龄小于等于 20 的员工信息
SELECT * FROM emp where age<=20;
-- 4.查询没有身份证号的员工信息
SELECT * FROM emp WHERE idcard is null;
-- 5.查询有身份证号员工的信息
SELECT * FROM emp WHERE idcard is not null;
-- 6.查询年纪不等于88的员工信息
SELECT * FORM emp where age != 88;
SELECT * FORM emp where age < >88;
-- 7.查询年龄在15岁(包含)到20岁(包含)之间的员工信息
SELECT * FORM emp where age <= 15 && age <= 20;
SELECT * FORM emp where age <= 15 and age <= 20;
SELECT * FORM emp where age between 15 and 20;
-- 8.查询性别为 女 且年龄小于25岁的员工信息
SELECT * FROM emp where gender = '女' and age < 25;
-- 9.查询年龄等于18 或20 或40的员工信息
SELECT * FROM emp where age = 18 or age = 20 or age = 40;
SELECT * FORM emp where age in( 18, 20, 40 );
-- 10.查询姓名为 两个 字的员工信息
SELECT * FORM emp where name like'_ _';
-- 11.查询身份证号最后一位是X的员工信息
SELECT * FORM emp where name like'%x'