A: "SELECT AVG(price) FROM product "是子查询
B: "ORDER BY price DESC"是指按price从低到高顺序排列
C: 查询结果显示的是大于平均价格的产品记录
D: 此查询显示的字段只有"productName"和"price"
举一反三
- 智慧职教: 查询Product（商品表 ）中销售价格比所有商品平均价格低的商品信息。 完成SQL语句。 SELECT Product.* FROM Product WHERE Price (Select 平均价格= (Price) From Product )
- 下面在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降序排序的语句是( )。[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;
- 在SQL Server 数据库中，从product表里查询出price（价格）高于pName（产品名称）为“一次性纸杯”所有记录中最高价格的产品的查询语句为（ ）。 A: SELECT * FROM product WHERE max(price)>'一次性纸杯' B: SELECT * FROM product WHERE price>(SELECT max(*) FROM product WHERE pName= '一次性纸杯') C: SELECT * FROM product WHERE EXISTS pName='一次性纸杯' D: SELECT * FROM product WHERE price>(SELECT max(price) FROM product WHERE pName='一次性纸杯')
- 查询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；
内容
- 0
【单选题】显示图书信息表中不同书架图书的平均价格大于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
- 1
【单选题】统计图书信息表中每个出版社图书的平均价格。能得到正确结果的SELECT语句是 A: A、select pubname,AVG(price) from bookinfo order by puname B: select pubname,AVG(price) from bookinfo group by pubname C: select pubname,price from bookinfo D: select pubname,AVG(price) from bookinfo
- 2
为查询Products表中,价格Price在5－10元之间的产品信息，请补全以下SELECT语句 SELECT ProductID,ProductName,Price FROM products WHERE_________ AND_________ A: price>=5,price<=10 B: price>5,price<10 C: price<=5,price<=10 D: price>=5,price>=10
- 3
为查询Products表中,价格Price在5－10元之间的产品信息，请补全以下SELECT语句 SELECT ProductID,ProductName,Price FROM products WHERE_________ AND_________
- 4
显示图书的最高价、最低价、平均价、最高价与最低价之间的差值。语句如下：SELECT Max(Price) AS 最高价, ________ AS 最低价, Str(Avg(Price),6,2) AS 平均价, Max(Price)-Min(Price) AS 最高价与最低价的差值FROM Book