Snippet Name: SELECT with HAVING Clause Description: The HAVING clause was added to SQL because the WHERE keyword can not be used by itself with aggregate functions. Also see:» TABLE: Using Select Statement With Data » SELECT: Case insensitive search » SELECT: Partition Select » SELECT: Select For Update » SELECT: Using Functions » SELECT: Get DISTINCT or UNIQUE values » SELECT: Get UNIQUE and DISTINCT values » SELECT: Scalar Select » SELECT with GROUP BY Clause » SELECT with WHERE Clause » SELECT with SAMPLE clause » SELECT placement » SELECT into a table » SELECT name columns » SELECT » UPDATE: Update from a SELECT statement » Inserting into SELECT statement » INSERT with Select Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 10th, 2009
Description: The HAVING clause was added to SQL because the WHERE keyword can not be used by itself with aggregate functions.
Also see:» TABLE: Using Select Statement With Data » SELECT: Case insensitive search » SELECT: Partition Select » SELECT: Select For Update » SELECT: Using Functions » SELECT: Get DISTINCT or UNIQUE values » SELECT: Get UNIQUE and DISTINCT values » SELECT: Scalar Select » SELECT with GROUP BY Clause » SELECT with WHERE Clause » SELECT with SAMPLE clause » SELECT placement » SELECT into a table » SELECT name columns » SELECT » UPDATE: Update from a SELECT statement » Inserting into SELECT statement » INSERT with Select
SELECT column_name, aggregate_function(column_name) FROM table_name WHERE column_name OPERATOR VALUE GROUP BY column_name HAVING aggregate_function(column_name) OPERATOR VALUE -- see if any of the customers have a total order of -- less than 2000. SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY Customer HAVING SUM(OrderPrice)<2000