查询book表中book_name字段和book_price字段的信息,查询语句是
A: select book_name,book_price from book
B: select * from book
C: select book from book_name,book_price
D: select * from book book_name,book_price
A: select book_name,book_price from book
B: select * from book
C: select book from book_name,book_price
D: select * from book book_name,book_price
举一反三
- 查询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;
- 智慧职教: 查询book表中book_name字段和book_price字段的信息,查询语句是
- 以下____完整,语句的作用是:查询book表中图书价格大于图书均价的图书信息select * from book where _____>;(select avg(price) from Book )
- 以下语句的作用是:查询book表中图书价格大于图书均价的图书信息 select * from book where _____>( select avg(price) from Book ) 则____处的内容为,
- 查询不比计算机类图书便宜的书,语句中SELECT name ,price from book where price____(select price from book where category='计算机')缺省的部分应是()。 A: > all B: > any C: