-- 查询年龄为20,21,22,23的女性员工信息
SELECT * FROM emp WHERE age BETWEEN 20 and 23 AND gender='女';
SELECT * FROM emp WHERE gender='女' and age IN(20,21,22,23);
-- 查询性别男,20-40名字为两个字的员工
SELECT * FROM emp WHERE gender='男'AND age BETWEEN 20 and 40 AND `name` LIKE '__';
-- 统计员工表中,年龄小于20的男性和女性人数;
SELECT gender,COUNT(*) FROM emp WHERE age<20 GROUP BY gender;
-- 查询年龄小等于20的员工年龄姓名,并对查询结果按照年龄升序排列,年龄相同按照入职时间降序排列;
SELECT `name`,age ,entrydate FROM emp WHERE age<=20 ORDER BY age,entrydate DESC;
-- 查询男,年龄在18-20之间的前5个员工的信息,结果按照年龄升序,入职时间升序排列;
SELECT * FROM emp WHERE gender='男' AND age BETWEEN 18 AND 20 ORDER BY age ASC,entrydate ASC LIMIT 0,5;
各种语句总结:
DQL语句的执行顺序以及编写顺序: