HAVING is supported by TARGIT InMemory Database Server. The ALIAS from the select part of the query is used along with the keyword Having - or else an aggregate expression.
Example:
SELECT item, sum(qty) AS quantity_sum FROM sometable HAVING quantity_sum>100ORSELECT item, sum(qty) AS quantity_sum FROM sometable HAVING sum(qty)>100
Overview
Content Tools