下面在sh_goods表中根据cat_id升序排序,并对每个cat_id按price降序排序的语句是( )。
SELECT * FROM sh_goods ORDER BY price DESC,cat_id;
SELECT * FROM sh_goods ORDER BY price ,cat_id;
SELECT * FROM sh_goods ORDER BY cat_id,price DESC;
SELECT * FROM sh_goods ORDER BY cat_id DESC,price;
