查询出多于两条记录的用户.txt

sql server 2000 系统 数 据 库 编 程

SELECT CustomerID, COUNT(CustomerID) AS COUNT
FROM Orders
GROUP BY CustomerID
HAVING COUNT(CustomerID) > 1