下面在sh_goods表中根据cat_id升序排序,并对每个cat_id按price降序排序的语句是( )。[br][/br](1.0)
A: SELECT * FROM sh_goods ORDER BY price DESC,cat_id;
B: SELECT * FROM sh_goods ORDER BY cat_id,price DESC;
C: SELECT * FROM sh_goods ORDER BY price ,cat_id;
D: SELECT * FROM sh_goods ORDER BY cat_id DESC,price;
A: SELECT * FROM sh_goods ORDER BY price DESC,cat_id;
B: SELECT * FROM sh_goods ORDER BY cat_id,price DESC;
C: SELECT * FROM sh_goods ORDER BY price ,cat_id;
D: SELECT * FROM sh_goods ORDER BY cat_id DESC,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 DESC,price; D: SELECT * FROM sh_goods ORDER BY cat_id,price DESC;
- 下面在sh_goods表中根据cat_id升序排序,并对每个cat_id按price降序排序的语句是()。 A: SELECT*FROMsh_goodsORDERBYpriceDESC,cat_id; B: SELECT*FROMsh_goodsORDERBYprice,cat_id; C: SELECT*FROMsh_goodsORDERBYcat_id,priceDESC; D: SELECT*FROMsh_goodsORDERBYcat_idDESC,price;
- 查询主键id从高到低排序的前10条记录的语句是（） A: SELECT * FROM table ORDER BY id ASC limit 1,10 B: SELECT * FROM table ORDER id DESC limit 10 C: SELECT * FROM table ORDER BY id DESC limit 10 D: SELECT * FROM table ORDER id ASC limit 1,10
- 输出公司的名称及id，以id的升序排列 A: SELECT name, id FROM job ORDER BY id ASC; B: SELECT name, id FROM job ORDER BY id DESC; C: SELECT name, id FROM job ORDER BY name DECS; D: SELECT name, id FROM job ORDER BY name ASC;
- 统计每个部门中人数的语句是？ A: select count(id) from emp order by deptno; B: select sum(id) from emp order by deptno; C: select count(id) from emp group by deptno; D: select sum(id) from emp group by deptno;