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>100
OR
SELECT item, sum(qty) AS quantity_sum FROM sometable HAVING sum(qty)>100
Comments
Please sign in to leave a comment.