sql - sql server查询: how to select customers with more than 1 order

我是一个SQL Server新手，并尝试选择具有超过1个orderid的所有客户。该表如下所示:

CREATE TABLE [dbo].[orders](
    [customerid] [int] NULL,
    [orderid] [int] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[orders] ([customerid], [orderid]) VALUES (1, 2)
INSERT [dbo].[orders] ([customerid], [orderid]) VALUES (1, 3)
INSERT [dbo].[orders] ([customerid], [orderid]) VALUES (2, 4)
INSERT [dbo].[orders] ([customerid], [orderid]) VALUES (2, 5)
INSERT [dbo].[orders] ([customerid], [orderid]) VALUES (3, 1)

最佳答案

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

关于sql - sql server查询: how to select customers with more than 1 order，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/17738938/