Wednesday, 18 September 2013

mysql orderby on column after groupby

mysql orderby on column after groupby

I have a table with the following fields: season, collection, product_key,
aggregated_sale. following query is not giving expected output
select t.* from (SELECT * FROM rank_processing.aggregate_season_product
order by aggregated_sale) t group by
t.collection,t.forecast_name,t.product_key;

No comments:

Post a Comment