Actually I am looking for duplicates (vedor_no, date), but I think I can 
hopefully adapt the solution you have given me.

[EMAIL PROTECTED] wrote:  
If you are looking just for duplicate (ID,vendort_no) combinations, this will 
find them: 
 
SELECT ID, vendor_no, count(1) as dupes 
FROM table_name_here 
GROUP BY ID, vendor_no 
HAVING dupes >1; 
 
Shawn Green
 Database Administrator
 Unimin Corporation - Spruce Pine 
 
 
Richard Reina <[EMAIL PROTECTED]> wrote on 02/23/2006 12:49:28 PM:
 
 > I's so sorry. You are very correct. The sample data is bad.  ID 
 > should be unique. Here it is corrected.
 > 
 >  |ID    | vendor_no        | date        |
 >  |2354  | 578              | "2005-12-23"|
 >  |2355  | 334              | "2005-12-24"|
 >  |2356  | 339              | "2005-12-26"|
 >  |2357  | 339              | "2005-12-26"|
 >  |2358  | 339              | "2005-12-26"|
 >  |2359  | 445              | "2005-12-26"|
 >  |2360  | 522              | "2005-12-27"|
 >  |2361  | 522              | "2005-12-27"|
 >  
 >  
 > [EMAIL PROTECTED] wrote: > I am a novice when it come to queries 
 > such as this and  was hoping 
 > > someone could help me write a query that tells me how many records 
 > > have the same ID and vendor number.
 > > 
 > > |ID    | vendor_no        | date        |
 > > |2354  | 578              | "2005-12-23"|
 > > |2355  | 334              | "2005-12-24"|
 > > |2356  | 339              | "2005-12-26"|
 > > |2357  | 339              | "2005-12-26"|
 > > |2358  | 339              | "2005-12-26"|
 > > |2359  | 445              | "2005-12-26"|
 > > |2354  | 522              | "2005-12-27"|
 > > |2355  | 522              | "2005-12-27"|
 > > 
 > > Would I use select count? Any help would be greatly appreciated.
 > 
 > I'd need a clearer spec to offer advise.  What results would you want
 > from the example data?  2354 is there twice but with different vendor
 > numbers.  And 522 is there twice with different IDs.  One interpretation
 > of "[records with] the same ID and vendor number" is 0 because no record
 > has both the same as any other.
 > 
 > 
 > 
 > 
 > 
 > A people that values its privileges above its principles soon loses both.
 >  -Dwight D. Eisenhower.



A people that values its privileges above its principles soon loses both.
 -Dwight D. Eisenhower.

Reply via email to