reverse group by in mysql

[itnassol]

Hi again,

is it possible to change the order of GROUP BY.

e.g. i have 3 rows of data all related to unit number 313025 as below

313025 - Red - Yellow - NoData
313025 - Red - Green - Green
313025 Green - Green - Green

When i do a GROUP BY Unit i get the following

313025 - Red - Yellow - NoData

or the fist one in the group that was entered, what i want is on a GROUP BY for it to show up the last record

Any ideas would be great

Thanks

Andrew

[mwasif]

This is called groupwise maximum. Take a look at this article.