Jack Bates schrieb:
Given columns a, b, and c, where I GROUP BY a, how do I get the value of
column b in each group which corresponds to the maximum value of column
c?
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
--
Sebastian Mendel
--
MySQL General Mailing Lis
Given columns a, b, and c, where I GROUP BY a, how do I get the value of
column b in each group which corresponds to the maximum value of column
c?
I have a table which contains some translated records. Column a is the
record id, column b is a translated field e.g. the title, and column c
is a lan