Penggunaan syntax HAVING clause pada SQL Statement: SELECT column1, column2, … column_n, aggregate_function (expression) FROM tables WHERE predicates GROUP BY column1, column2, … column_n HAVING condition1 … condition_n; Example using the SUM function SELECT department, SUM(sales) as “Total sales” FROM order_details GROUP BY department HAVING SUM(sales) > 1000; Example using the COUNT function SELECT department, [...]
Archive for the ‘:.SQL&DB’ Category
..:SQL(Sequel)
Posted in :.Oracle PL/SQL, :.SQL&DB on November 28, 2007 | 2 Comments »
