A: all
B: any
C:
D:
举一反三
- 查询不比计算机类图书便宜的书,语句中SELECT name ,price from book where price____(select price from book where category='计算机')缺省的部分应是（）。 A: > all B: > any C:
- 查询比计算机类图书便宜的书,语句中 SELECT name ,price from book where price____ (select price from book where category='计算机')缺省的部分应是（）。 A: > all B: > any C: < any D: < all
- 查询book表中price字段的最大值，查询语句是： A: select max(price) from book； B: select min(price) from book； C: select price from min book； D: select price from max book；
- 查询被借阅过的图书,语句 SELECT name from book where( ) 的条件,下列哪[br][/br]一个不能实现. A: no =all (select bno from borrow) B: no =any (select bno from borrow) C: no in (select bno from borrow) D: exists (select * from borrow where bno=book.bno)
- 【单选题】显示图书信息表中不同书架图书的平均价格大于50元的书架号和平均价格。能得到正确结果的SELECT语句是 A: select casename,AVG(price) <br> from bookinfo group by casename where AVG(price)>50 B: select casename,AVG(price)>50 from bookinfo group by casename C: select casename,AVG(price) <br> from bookinfo<br> having AVG(price)>50 group by casename D: select casename,AVG(price) <br> from bookinfo group by casename<br> having AVG(price)>50
内容
- 0
分析以下SQL 命令执行后的输出结果是( )。[br][/br]SELECT price[br][/br]FROM inventory[br][/br]WHERE price BETWEEN 1 AND 50[br][/br]AND (price IN(55, 30, 95); A: 55 B: 95 C: 30 D: NULL
- 1
以下____完整，语句的作用是：查询book表中图书价格大于图书均价的图书信息select * from book where _____>;(select avg(price) from Book )
- 2
要修改book(id,name,price)表中所有书名中以“计算机”开头的书籍的价格上幅5元，可用( ）语句。 A: UPDATE book SET price =price+5 WHERE name = ‘计算机*’ B: UPDATE book SET price =price+5 WHERE name LIKE ‘计算机*’ C: UPDATE book SET price =price+5 WHERE name LIKE = ‘计算机%’ D: UPDATE book SET price =price+5 WHERE name LIKE ‘计算机%’
- 3
下面在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;
- 4
查询“图书”表中书名含有“计算机”的图书信息，正确的选项是______。 A: select * from book where bname like ‘_计算机_’ B: select * from book where bname like ‘_计算机%’ C: select * from book where bname like ‘%计算机_’ D: select * from book where bname like ‘%计算机%’