DEV Community

Alverson Layne
Alverson Layne

Posted on

Answer: sql server query: how to select customers with more than 1 order

select  customerid
,       count(*) as order_count
from    orders
group by
        customerid
having  count(*) > 1



?signin=true

Top comments (0)