Uzaren.com

MySQL: different ORDER inside GROUP BY structure

Example:

SELECT * FROM (

  SELECT *
  FROM table AS table1
  WHERE statment_column='condition'
  ORDER BY order_column DESC

) AS table2

GROUP BY group_column