Specifies a search condition for a group or an aggregate. HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause.
Transact-SQL Syntax Conventions
[ HAVING <search condition> ]
Specifies the search condition for the group or the aggregate to meet.
, text , and image data types cannot be used in a HAVING clause. ntext
The following example that uses a simple
HAVING clause retrieves the total for each SalesOrderID from the SalesOrderDetail table that exceeds $100000.00.
USE AdventureWorks2012 ;
SELECT SalesOrderID, SUM(LineTotal) AS SubTotal
GROUP BY SalesOrderID
HAVING SUM(LineTotal) > 100000.00
ORDER BY SalesOrderID ;
Did you find this helpful?
( 1500 characters remaining)
Thank you for your feedback