Re: Disregard duplicates based on a field
- From: "Ed Prochak" <edprochak@xxxxxxxxx>
- Date: 28 Apr 2006 16:29:53 -0700
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;
???
.
- Follow-Ups:
- Re: Disregard duplicates based on a field
- From: Michel Cadot
- Re: Disregard duplicates based on a field
- References:
- Disregard duplicates based on a field
- From: mBird
- Disregard duplicates based on a field
- Prev by Date: Re: data dictionary query with 7million consistent gets ! ? !
- Next by Date: Re: Disregard duplicates based on a field
- Previous by thread: Re: Disregard duplicates based on a field
- Next by thread: Re: Disregard duplicates based on a field
- Index(es):
Relevant Pages
|
|
