Karen and Bill: thank you very much. that did the trick. now onto the next hurdle.
bruce chitiea safesectors, inc. > -------- Original Message -------- > Subject: [RBASE-L] - Re: Data Import Cleanup: Selecting > "Semi"-Duplicates > From: [email protected] > Date: Thu, August 12, 2010 12:55 pm > To: [email protected] (RBASE-L Mailing List) > > > Bruce: Try this: > > select all from <your table> where mvplateno IN + > (select mvplateno from <your table> + > group by mvplateno having count(*) >1 ) > > Karen > > > > > After importing Excel vehicle records into a receiving table, I ran a > > "SELECT DISTINCT ..." against all necessary columns in a working copy of > > the receiving table. > > > > This revealed 'semi-distinct' records such as these: > > > > mvplateno mvplatestateid mvcolorid mvmfgrid mvmodel ... > > (Indexed) (Indexed) > > > > 112 BLG CA WHT CHV MALIBU > > 112 BLG CA WHT -0- -0- > > 112 BLG CA -0- CHV IMPALA > > 112 BLG FL -0- -0- -0- > > > > 123 ABC CA RED HON CIVIC > > 123 ABC CA HON RED ACCORD > > 123 ABC CA MAR TOY ACCORD > > > > I'm thinking a form-hosted, cursor-stepped editing process; producing a > > list of truly distinct records keyed off the license plate number > > (mvplateno). > > > > Where I'm hung up is how to select out only those records where > > (count(mvplateno) >1). > > > > I'd sure appreciate a pointer in the correct use of SELECT to generate a > > subset based solely on record-count. > > --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
