Hi,
I heard that keylin does not support Having-clause like bellow. Does anyone can 
give confirmation on it?
If it's already supported, since which version?

The example table:
O_Id
OrderDate
OrderPrice
Customer
12008/12/291000Bush
22008/11/231600Carter
32008/10/05700Bush
42008/09/28300Bush
52008/08/062000Adams
62008/07/21100Carter

and the query code(select users which have sum of OerderPrice less than 2000):
SELECT Customer,SUM(OrderPrice) FROM Orders
GROUP BY Customer
HAVING SUM(OrderPrice) < 2000

Thanks,
Quanfu

Reply via email to