分析以下SQL 命令: SELECT price FROM inventory WHERE price BETWEEN 1 AND 50 AND (price IN(55, 30, 95); 命令执行后的输出结果是:()
A: 55
B: 30
C: 95
D: NULL
A: 55
B: 30
C: 95
D: NULL
举一反三
- 分析以下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
- 使用SQL语句将表s中字段price的值大于30的记录删除,正确的命令是( )。 A.DELETE FROM S FOR price>30 B.DELETE FROM sWHERE price>30 C.DELETE S FOR price>30 D.DELETE S WHERE price>30
- 查询图书价格在30到50之间的图书名、作者和出版社,其中的查询条件表达式为() A: where price>;=30 AND price<;=50 B: where price>;=30 OR price<;=50 C: where priceBETWEEN 30 AND 50 D: where priceBETWEEN50 AND 30
- 有如下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"
- 【单选题】显示图书信息表中不同书架图书的平均价格大于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