Unique records

[Guest]

Hi,

I have a table which looks like this:
A B C D E F G
1 2 3 4 5 6 7
1 2 3 4 6 7 8
1 2 3 4 7 8 9
1 2 3 4 8 9 1
1 2 3 4 9 1 2
2 3 4 5 6 7 8
2 3 4 5 7 8 9
2 3 4 5 8 9 1
2 3 4 5 9 1 2

Columns A,B,C and D have duplicates but E,F and G have no duplucates. I need
a query that gives me unique A,B,C and D and any of the E,F and G records but
just one. It could be the first or second, doesn't matter but I need one row
for A,B,C and D.
Is this possilble?

thanx

 

[Duane Hookom]

Try
SELECT A, B, C, D, Min(E) as MinE, Min(F) as Min(G) as MinG
FROM [which looks like this]
GROUP BY A, B, C, D;