书写优先顺序:
(1) SELECT
(2) FROM
(3) WHERE
(4) GROUP BY
(5) HAVING
(6) ORDER BY
(7) LIMIT
例如:
SELECT *
FROM student
WHERE sex = “女”
HAVING birthday > ‘2016-12-05’
ORDERBY stuid
LIMIT 10;
(或者LIMIT 0,3)
查询语句注意
GROUP BY和HAVING的顺序
HAVING是对GROUP BY分组后的数据进行筛选,也就是说它必须放在GROUP BY后面。
有关日期的书写方式
SELECT * from order
WHERE odate BETWEEN ‘2016-12-05’ AND ‘2016-12-15’
LIMIT 1,3:
查询3条数据,但数据从第二条开始算
LIMIT 10
表示只查询10条数据