Can someone help?

[TGJ]

I have a table called "Bidders". Some bidders have the same BuyerNum. I need to select only the BuyerNum's that have two or more Bidders associated with it. I dont think this is very hard but I am still learning SQL, thanks for any help.

This is the idea:
SELECT BuyerNum from Bidders where "two or more Bidders have the same BuyerNum";

 

[TGJ]

Different Bidders can be identified by BidderID

 

[r937]

SELECT BuyerNum
from Bidders
group by BuyerNum
having count(distinct BidderID) > 1

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)