Oracle/GROUP BY, HAVING 썸네일형 리스트형 GROUP BY, HAVING GROUP BY and HAVING By including a GROUP BY clause functions such as SUM and COUNT are applied to groups of items sharing values. When you specify GROUP BY region the result is that you get only one row for each different value of region . All the other columns must be "aggregated" by one of SUM, COUNT ... The HAVING clause allows use to filter the groups which are displayed. The WHERE clause fi.. 더보기 이전 1 다음