题目
A.SELECT MIN (UnitPrice) AS最高单价FROM Products
B.SELECT AVG (UnitPrice) AS最高单价FROM Products
C.SELECT MAX (UnitPrice) AS最高单价FROM Products
D.SELECT MAX UnitPrice AS最高单价FROM Products
第1题
A.SELECT MIN (UnitPrice) AS最高单价FROM Products
B.SELECT AVG (UnitPrice) AS最高单价FROM Products
C.SELECT MAX (UnitPrice) AS最高单价FROM Products
D.SELECT MAX UnitPrice AS最高单价FROM Products
第2题
A.SELECT TOP 10 SUM(UnitPrice) AS单价之和FROM Products
B.SELECT SUM(UnitPrice) AS单价之和TOP 10 FROM Products
C.SELECT TOP 10 COUNT(UnitPrice) AS单价之和FROM Products
D.SELECT SUM(UnitPrice) TOP 10 AS单价之和FROM Products
第3题
A.SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 6 AND 10
B.SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
C.SELECT Name,UnitPrice FROM Products WHERE UnitPrice IN(6,8,10)
D.SELECT Name,UnitPrice FROM Products WHERE UnitPrice=6 OR UnitPrice=8 OR UnitPrice=10
第4题
A.SELECT pName, UnitPrice FROM Products WHERE UnitPrice BETWEEN 6 AND 10
B.SELECT pName, UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
C.SELECT pName, UnitPrice FROM Products WHERE UnitPrice IN(6,10)
D.SELECT pName, UnitPrice FROM Products WHERE UnitPrice>=6 AND UnitPrice<=10
第5题
A.SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 6 AND 10
B.SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
C.SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
D.SELECT Name,UnitPrice FROM Products WHERE UnitPrice>6 AND UnitPrice <10
第6题
A.SELECT pName, UnitPrice FROM Products WHERE UnitPrice BETWEEN 6 AND 10
B.SELECT pName, UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
C.SELECT pName, UnitPrice FROM Products WHERE UnitPrice IN(6,10)
D.SELECT pName, UnitPrice FROM Products WHERE UnitPrice>=6 AND UnitPrice<=10
第7题
A.SELECT pName, UnitPrice FROM Products WHERE UnitPrice BETWEEN 6 AND 10
B.SELECT pName, UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
C.SELECT pName, UnitPrice FROM Products WHERE UnitPrice IN(6,10)
D.SELECT pName, UnitPrice FROM Products WHERE UnitPrice>=6 AND UnitPrice<=10
第8题
A.SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 6 AND 10
B.SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
C.SELECT Name,UnitPrice FROM Products WHERE UnitPrice IN(6,10)
D.SELECT Name,UnitPrice FROM Products WHERE UnitPrice>=6 AND UnitPrice<=10
第9题
A.select top 2 * from 销售表 where 类型=‘04’ group by 单价 desc
B.select top 2 * from 销售表 where 类型=‘04’ order by 单价 desc
C.select top 2 * from 销售表 where 类型=‘04’ group by 单价
D.select top 2 * from 销售表 where 类型=‘04’ order by 单价
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!