Hi!
I have a problem figuring out how to formulate my select-query. I will try to illustrate my problem
Table:
col1 | col2
-----------
A | 10
B | 13
B | 14
C | 11
I want to select every distinct occurence in col1 choosing the record with the highest value in col2, ie. i want the result set to be:
col1 | col2
-----------
A | 10
B | 14
C | 11
Any clues as how to do this? Any help wold be appreciated!
Regards,
Jonas
I have a problem figuring out how to formulate my select-query. I will try to illustrate my problem
Table:
col1 | col2
-----------
A | 10
B | 13
B | 14
C | 11
I want to select every distinct occurence in col1 choosing the record with the highest value in col2, ie. i want the result set to be:
col1 | col2
-----------
A | 10
B | 14
C | 11
Any clues as how to do this? Any help wold be appreciated!
Regards,
Jonas