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;