Oracle/SUM, COUNT, MAX, AVERAGE 썸네일형 리스트형 SUM, COUNT, MAX, AVERAGE, DISTINCT, ORDER BY Aggregates The functions SUM, COUNT, MAX and AVG are "aggregates", each may be applied to a numeric attribute resulting in a single row being returned by the query. (These functions are even more useful when used in conjunction with the GROUP BY clause.) Distinct By default the result of a SELECT may contain duplicate rows. We can remove these duplicates using the DISTINCT key word. Order by ORD.. 더보기 이전 1 다음