Re: SQL question, SELECT DISTINCT

[leegold]

On Mon, 16 Aug 2004 11:36:32 -0400, SGreen@stripped said:
> It all depends on which values of f1 you want to ignore.
> 
> f1      f2     f3
> -----   -----  ------
> val1-1  val2   val3
> val1-2  val2   val3
> val1-3  val2   val3
> 
> Which value of f1 would you want in your new table? Which ones to ignore? 

I want the DISTINCT to ignore the f1 column completely. But I want all 3
cols. ie. the entire row selected though. Pretend that f1 is a unique PK
it'll always be different, I want to DISTINCT to ignore it, so if 2 or
mores row have dup f2 *and* f3 Distinct will let only one through.


> Are there other columns (beyond these 3) to move as well?

Nope. Just 3 cols. Thanks

> 
> Yours,
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
> 
> "leegold" <leegold@stripped> wrote on 08/16/2004 11:29:33 AM:
> 
> > say I'm selecting distinct (non-duplicate) rows for insertion,
> > 
> > insert into original_table select distinct * from new_table
> > 
> > these tables have 3  fields/row. Per the above code all 3 fields are 
> > evaluated by "distict *" .
> > 
> > But my question is: I want to ignore field1, therefore I only want to 
> > test if any rows have field2 *and* field3 as dups - that would be my 
> > distinct test and then do the insert based on that. Test f2 and f3, not
> > f1.
> > 
> > What the sql? Help is greatly appreciated.
> > 
> > -- 
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> >