Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 query count

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-28 : 16:35:07
cliff writes "I have a purchase_order table with a customer_id column. How do I write a query that lists the number of purchase orders in the purchase_order table with 2 or more of the same customer_id?

Please email me the answer! I know it's a subquery, but I haven't been able to figure it out, though it should be simple."
   

- Advertisement -