query that returns no duplicates

[haytatreides]

Hi all, I have a table structed like this

fld1 fld2 fld3 fld4
1234 bbbb cccc 1111
1235 bbbb cccc 1111
1236 bbbb dddd 2222
1237 eeee dddd 2222
1238 eeee dddd 2222

what i want to do is list in the query, data that is not a duplicate of fields 2,3, and 4. so if those three fields are duplicated in combination, then list them once, like 1237 and 1238, list only 1237. does anyone have any idea how to do this??? i have searched the posts, but found nothing too close to what i need. I am guessing there is a way to use distinct, but i have no idea how. Please help me, and I will give you my first born.

 

[mpastore]

select min(fld1),fld2,fld3,fld4
from table1
group by fld2,fld3,fld4


Mike Pastore

Hats off to (Roy) Harper

 

[haytatreides]

thanks, i actually just concatenated them and assigned an alias then did a distinct.