1、SQL的各种join用法
下面是 LEFT JOIN、RIGHT JOIN、INNER JOIN、FULL OUTER JOIN 相关的 7 种用法:
注意:MySQL不支持full outer join,可以通过left join() union right join()来实现
2、关键字的顺序
关键字顺序:SELECT ... FROM ... WHERE ... GROUP BY ... HAVING ... ORDER BY ...
3、聚合函数
当你使用了聚合函数,如sum/avg/count等,这时候想用于筛选,需要用having进行筛选。如:select sid,avg(score) as s_avg from sc group by Sid having avg(score)>=60;
4、 group_concat()用法
group_concat,它能将group by 后的列,在同一行中展示出来,如: