Using this SQL: SELECT sb1.date, sb1.branch, sb1.build FROM stable_builds sb1 INNER JOIN ( SELECT max(date) date, branch FROM stable_builds GROUP BY branch ) AS sb2 ON sb1.branch = sb2.branch AND sb1.date = sb2.date ORDER BY date DESC Data: Date Branch Build 2014-11-24 5.6 460049 2014-11-19 5.6 459641 2014-11-16 5.6 459347 Output: Date Branch Build 2014-11-24 5.6 460049
No comments:
Post a Comment