SQL Question - Select customers with more than 3 orders...

[ska]

Hi,

I have a table called ORDERS in a SQL Server 2000 database and I need to get a list of all the customers with more than 3 orders. Here is my ORDERS table structure:

OrderID INT PK
CustomerID INT
OrderDate DATETIME
OrderAmount FLOAT

Do you know how to select all customers (CustomerID) appearing more than 3 times in the ORDERS table?



Thanks
_________________
Ska Forever :/

[paul]

You'll have to use the SQL HAVING command to do that, like this:

[x-raysteve]

Learn something new the other day. I had something I was trying to debug the other day and this would have come in helpful. I never even heard of the having command before.