单选题：下面在sh_goods表中根据cat_id升序排序，当cat_id相同时按price降序排序的语句是：

下面在sh_goods表中根据cat_id升序排序，当cat_id相同时按price降序排序的语句是：



A.
SELECT * FROM sh_goods ORDER BY price DESC,cat_id;

B.
SELECT * FROM sh_goods ORDER BY price ,cat_id;

C.
SELECT * FROM sh_goods ORDER BY cat_id,price DESC;

D.
SELECT * FROM sh_goods ORDER BY cat_id DESC,price;



答案：C