从产品表Products中查询单价UnitPrice最高的商品单价,正确的SQL是()
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
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
A.unit price; gross weight
B.total value, net weight
C.unit price; net weight
D.total value; gross weight
A、select avg(price),type from book group by type
B、select count(price),type from book group by price
C、select avg(price),type from book group by price
D、select count (price),type from book group by type
A、select cid,count(distinct(cid)),sum(money) from orders group by cid
B、select cid,count(distinct(cid)),sum(money) from orders order by cid
C、select cid,count(cid),sum(money) from orders order by cid
D、select cid,count(cid),sum(money) from orders group by cid
A、select productid from orders where count(productid)>1
B、select productid from orders where max(productid)>1
C、select productid from orders where having count(productid)>1 group by productid
D、select productid from orders group by productid having count(productid)>1
A、Select * into customers from clients
B、Select into customers from clients
C、Insert into customers select * from clients
D、Insert customers select * from clients
A、SELECT * FROM 产品WHERE 价格>‘一次性纸杯’
B、SELECT * FROM 产品WHERE 价格>(SELECT * FROM 产品WHERE 产品名称>’一次性纸杯’)
C、SELECT * FROM 产品WHERE EXISTS 产品名称=’一次性纸杯’
D、SELECT * FROM 产品WHERE 价格>(SELECT 价格FROM 产品WHERE 产品名称=’一次性纸杯’)
A、10
B、6
C、4
D、0
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!