group by grouping sets 的用法
group by grouping sets 的用法先看group by:SELECT A FROM T GROUP BY A; 对//返回的结果就是按照字段A分,列出这几种SELECT A,B FROM T GROUP BY A; 错SELECT A,SUM (B) FROM T GROUP BY A; 对这就是说,在select指定的字段要么就要包含在Group By语句的后面...
原创
2019-08-13 09:58:58 ·
14208 阅读 ·
1 评论