Hello.
I have a table
create table foo (
a serial,
b int,
c int,
.... more fields ...);
and now I wish to remove for each combination of b and c, all the
rows except the one with the highest value of a.
For example
a b c other fields
=====
1 5 5 .....
2 5 5 ....
3 2 3 ....
4 2 2 ...
5 5 5 ...
should leave
a b c other fields
=====
3 2 3 ....
4 2 2 ...
5 5 5 ...
is there some clever command for this or will I have to write a
special function that loops through all values of b and c ?