'Hybris flexible extract order id which has more than 10 products

I need to extract order id which has more than 10 products. Could you please suggest me the flexible search query.

hybris

Solution 1:^[1]

Hi Please use group by with having clause.

select {o.code} from {Order as o join OrderEntry as oe on {oe.order}={o.pk}}
group by {o.code} having count({o.code})>10

reference to use having clause: having clause

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	Raushan Kumar