Removing duplicate record from a query

[Eddy Sincere]

I have a query that pulls data in the following format:

A - B
1 - 2


1 - 3
2 - 4
3 - 5

I want the query to eliminate record 1 - 2 and keep 1 - 3. Is that possible?

Everything I've read tells me I can only eliminate duplicate records that are identical, therefore a query won't remove record 1 - 2 because the second column has a different value.

[pbaldy]

Try

SELECT A, Max(B) As MaxB
FROM TableName
GROUP BY A

[Eddy Sincere]

Yup, that worked. Thanks. That was driving me nuts.

[pbaldy]

Happy to help! Just noticed you live nearby. Greetings from north of you.

[Eddy Sincere]

I take it you're in Reno? That's about the only thing north of Carson. Well... that and a whole bunch of nothing. :-)

BTW - You can mark this as solved.

[pbaldy]

Done; it's in Thread Tools by the way.

Yep, in the biggest little city.