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 val2
1 1 2 3
2 1 2 4
3 2 1 1
4 1 0 5
5 2 1 8
Needed Result :
pk id val1 val2
4 1 0 5
5 2 1 8
Thx
berger