HAVING

The HAVING clause is used to specify a boolean condition that must be satisfied by a group for the group record to be output. Groups that do not satisfy the condition are discarded.

Examples:

A. Simple expression

HAVING EventID = 501

B. Complex expression

HAVING SUM(sc-bytes) > 100000 AND
       ( COUNT(*) > 1000 OR
         EXTRACT_EXTENSION(cs-uri-stem) LIKE 'htm'
       )

C. Complex expression

The following example query retrieves all the event sources from the System event log that generated more than 10 events:

SELECT SourceName
FROM System
GROUP BY SourceName
HAVING COUNT(*) > 10

See also:

Filtering Groups

© 2004 Microsoft Corporation. All rights reserved.