Return Customers with > 1 Orders of Specific Product??

• Don Guillermo des Las Colinas

  SSC Veteran

  Points: 236

  More actions

  October 21, 2004 at 3:50 pm

  #59634

  I apologize if I am posting in the wrong area. I don't even know how to search this forum for the answer to this one. I am a newbie as you'll see:

   

  I have a table in which orders are kept. I have a customerid and a productid. I need to return only the customerid's for those who have ordered > 1 of a specific peoductid.

   

  This sounds really simple but I've never had to do this. I tried to use a count(*) > 1 but to no avail.

   

  Is there any hope of finding this? I've left my sql reference at home and the client is coming to see in the AM ;(

   

  TIA: Rich

• David Scotland-132255

  SSCertifiable

  Points: 5599

  More actions

  October 21, 2004 at 4:02 pm

  #527551

  If i understand you correctly something along the lines of

  SELECT CUSTOMERID, PRODUCTID

  FROM TABLE

  GROUP BY CUSTOMER ID, PRODUCTID

  HAVING COUNT(*) > 1

  hth

  Dave