Using the from method to find the latest products under each column, why are the results incorrect?

Question

Use the from method to find the latest products under each column. Why are the results incorrect?

select goods_id,cat_id,goods_name from (select * from goods where 1 order by cat_id asc,goods_id desc )as tep group by cat_id;

Answer 1

Grouping-》Sort-》Get the latest