Avatar of fjkaykr11
fjkaykr11
 asked on

SQL Query

I am working with a Select Query (SQL Server 2000) where I want to filter for the number of orders being placed for a specific item. For the Query below
I want to bring back only customers who placed an order for ItemCode='100' more than two times. Any ideas on how I can do this?  Thanks.


Select Customer.CustomerID
from Customer
JOIN Orders on Customer.CustomerID = Orders.CustomerID
WHERE
Orders.ItemCode ='100'
Microsoft SQL ServerSQL

Avatar of undefined
Last Comment
fjkaykr11

8/22/2022 - Mon
SOLUTION
mimran18

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
plusone3055

Select Customer.CustomerID
from Customer
JOIN Orders on Customer.CustomerID = Orders.CustomerID
WHERE
Orders.ItemCode ='100'
and Customer.customerID HAVING COUNT(*) > 2
fjkaykr11

ASKER
thanks for both replies.  Both queries look similar.  Which one is correct or does it matter?
ASKER CERTIFIED SOLUTION
Anthony Perkins

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
fjkaykr11

ASKER
Thanks for the help
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes