当前位置：网站首页>GBase 8s V8. 8 SQL Guide: tutorial-6.1

GBase 8s V8. 8 SQL Guide: tutorial-6.1

2022-04-22 05:26:00 【Gbase database】

6.1 GROUP BY and HAVING Clause
Optional GROUP BY and HAVING Clause direction SELECT Add... Function . Can be in the basic SELECT language
Include one or all two clauses in a sentence to increase the ability to deal with aggregation .
GROUP BY Clause combines similar rows , in the light of Projection Each column listed in the clause , For each with the same value
Group rows generate a single result row .HAVING Clause sets conditions for those groups after they are formed . You don't have to HAVING
Clause use GROUP BY Clause or without GROUP BY Clause use HAVING Clause .

版权声明
本文为[Gbase database]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204220524175750.html