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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Finding which row has max
Thanks, I didn't realize you could compare pairs of items using the IN statement. That makes for a much better solution. > where (category,vers) -
Finding which row has max
This is what I finially got to work. Is there a better way to do this? I'll add a few more details to explain why I have some of the stuff at the end. Oh, and I'm using MySQL v4.1.12 so I do have subqueries. SELECT p.id, p.category, CONCAT_WS('.', IFNULL(p.major, 0)... -
Finding which row has max
I am trying to find which row has the result produced by MAX(). I've tried quite a few different approaches, but I'm not getting what I want. Here is a simplified example: Table: prod_ver id category version 1 5 3 22 52 3 88 5 4 116 52 5 117 3...
