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;
内容
- 0
有表song(id,song_name,album,play_count,fav_count)分别表示歌曲的主键id、歌曲名、专辑名、播放次数和收藏次数，以下与order by相关的sql错误的是： A: select * from song order by play_count asc; B: select * from song order by (play_count + fav_count) asc; C: select * from song order by fav_count desc where play_count > 5; D: select * from song order by id,play_count asc,fav_count desc;
- 1
统计每个部门中的人数的语句是【】。 A: SELECT SUM(ID) FROM examp GROUP BY DE_NUM B: SELECT COUNT(ID) FROM examp ORDER BY DE_NUM C: SELECT COUNT(ID) FROM examp GROUP BY DE_NUM D: SELECT SUM(ID) FROM examp ORDER BY DE_NUM
- 2
下面的SQL查询语句中的排序方法是（ ）。 SELECT * FROM tb_student order by id,age desc;
- 3
有如下SQL语句: SELECT DISTINCT productName, price FROM product WHERE (price>;(SELECT AVG(price) FROM product)) ORDER BY price DESC; 下面说法错误的是( )。 A: "SELECT AVG(price) FROM product "是子查询 B: "ORDER BY price DESC"是指按price从低到高顺序排列 C: 查询结果显示的是大于平均价格的产品记录 D: 此查询显示的字段只有"productName"和"price"
- 4
如果要把查询结果按照字段id升序排序，再按字段title降序排序，下面哪个链式操作表达式满足这个需求： A: order(“id , title”) B: order(“id , title desc”) C: order(“id title desc”) D: order(“id asc title desc”)