Hello,
I have a problem, which I'm not able to solve with a simple query :
I need a resultset with distinct id's, but the max val2 of each id.
I tried to group by id, but though I need the pk in my resultset
I have to group it too, which "destroys" the group of val2.
Can this be done without a huge query ?
Table :
pk id val1 val21 1 2 32 1 2 43 2 1 14 1 0 55 2 1 8
Needed Result :
pk id val1 val24 1 0 55 2 1 8
Thx
berger