Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Select but not quite distinct =)
I realise I knew the answer to this one, but if I modify it slighly it gives me a headache again, like thus: Table: col1 | col2 | col3 -------------------- A | 10 | Z B | 13 | X B | 14 | X C | 11 | Y Now, if I use SELECT DISTINCT col1, MAX(col2), col3 FROM Table GROUP... -
Select but not quite distinct =)
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...
