如要使用一个SELECT语句来显示价格(price)小于5.0的id_number，应使用如下的哪个子句
A: WHERE price＜5.00
B: HAVING price＜5.00
C: ORDER BY price＜5.00
D: GROUP BY price＜5.00
A: WHERE price＜5.00
B: HAVING price＜5.00
C: ORDER BY price＜5.00
D: GROUP BY price＜5.00
举一反三
- 有如下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
- 为查询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
- 阅读下面T-SQL语句，对变量赋值时存在错误的是（ ）（其中money为钱币数据类型，为其变量赋值可用或者不用$等货币符号）。 A: declare @id int ,@price money Set @id =100 Set @price=$2.21 B: declare @id int ,@price money Select @id=100,@price=2.21 C: declare @id int ,@price money set @id=100,@price=2.21 D: declare @id int ,@price money Select @id=100Select @price=$2.21
- 下面在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;