多项选择题
关于groupby以下语句正确的是()
A.SELECT store_name FROMStore_Information GROUP BY store_name
B.SELECT SUM(sales)FROM Store_Information GROUP BY sales
C.SELECT store_name,price SUM(sales)FROM Store_Information GROUP BY store_name,price
D.SELECT store_name,SUM(sales)FROM Store_Information GROUP BY store_name
点击查看答案
相关考题
-
多项选择题
以下哪些是mySQL数据类型()
A.BIGINT
B.TINYINT
C.INTEGER
D.INT -
多项选择题
下面检索结果一定不是一行的命令是()
A.select distinct*fromo rders;
B.select * from orders limit 1,2;
C.select top 1*from orders;
D.select * from orders limit 1; -
多项选择题
以下否定语句搭配正确的是()
A.not in
B.in not
C.not between and
D. is not null
