目录
一、 单表查询
小拓展:
SQL语句的执行顺序:
FROM > JOIN > WHERE > GROUP BY > HAVING > SELECT的字段 > DISTINCT > ORDER BY > LIMIT
例子如下:
SELECT DISTINCT `user`.id,`user`.`name`,t.price #顺序6 -- SELECT、7--DISTINCT FROM `user` #顺序1 JOIN orderlist as t ON t.uid = `user`.id #顺序2 WHERE t.price >1000 #顺序3 GROUP BY `user`.`name` #顺序4 HAVING t.price <10000 #顺序5 ORDER BY t.price DESC #顺序8 LIMIT 3 #顺序9
流程图如下: