Home
SQL / MySQL
Aggregate Functions
Backup Load
Command MySQL
Cursor
Data Type
Database
Date Time
Engine
Event
Flow Control
FullText Search
Function
Geometric
I18N
Insert Delete Update
Join
Key
Math
Procedure Function
Regular Expression
Select Clause
String
Table Index
Transaction
Trigger
User Permission
View
Where Clause
XML
HAVING « Select Clause « SQL / MySQL
SQL / MySQL
Select Clause
HAVING
1.
SELECT statement includes a HAVING clause that contains one condition:
2.
Include a WHERE clause-but only to select rows, not to test summary values.
3.
Shows those hours of the day during which no messages were sent by using a HAVING clause that selects only sum
4.
HAVING COUNT(*) > 1
5.
HAVING SUM(AMOUNT) > 150
6.
Determining Whether Values are Unique
7.
To find message sender/recipient pairs between whom only one message was sent