Re: Disregard duplicates based on a field

mBird wrote:
> I have a table with three fields:
> f1, f2, f3
> 1 a 432
> 2 b 323
> 3 a 345 <-- so 3 has an a and b entry
> 3 b 345 <-- so 3 has an a and b entry
>
> I need all the distinct f1's but when choosing which of the duplicates to
> keep be able to specify the priority choice of f2 being a. So...
> -if there is only one distinct f1 then I want that row regardless of f2
> -if there are multiple rows with the same f1's then I want the one that f2 =
> a
> 1 a 432
> 2 b 323
> 3 a 345
> (notice I kept 3 a 345 but discarded 3 b 345)
>
> Thank you!

what's wrong with:

select f1, MIN(f2), f3 from yourtable

   group by f1,f3;

??? Received on Fri Apr 28 2006 - 18:29:53 CDT