查询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;
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表中图书价格大于图书均价的图书信息select * from book where _____>;(select avg(price) from Book )
- 查询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表中图书价格大于图书均价的图书信息 select * from book where _____>( select avg(price) from Book ) 则____处的内容为,
- 语句Select avg(price)as 图书金额 from book中“图书金额”是book表的列。
- 以下语句的作用是:查询book表中图书价格大于图书均价的图书信息select * from book where _____>(select avg(price) from Book )则____处的内容为,