多項(xiàng)選擇題關(guān)于groupby以下語(yǔ)句正確的是()

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


您可能感興趣的試卷

你可能感興趣的試題

1.多項(xiàng)選擇題以下哪些是mySQL數(shù)據(jù)類(lèi)型()

A.BIGINT
B.TINYINT
C.INTEGER
D.INT

2.多項(xiàng)選擇題下面檢索結(jié)果一定不是一行的命令是()

A.select distinct*fromo rders;
B.select * from orders limit 1,2;
C.select top 1*from orders;
D.select * from orders limit 1;

3.多項(xiàng)選擇題以下否定語(yǔ)句搭配正確的是()

A.not in
B.in not
C.not between and
D. is not null

4.多項(xiàng)選擇題下列哪些列類(lèi)型是數(shù)值型的數(shù)據(jù)()。

A.DOUBLE
B.INT
C.SET
D.FLOAT

5.多項(xiàng)選擇題下面語(yǔ)句中,表示過(guò)慮條件是vend_id=1002或vend_id=1003的是()

A.select * from products where vend_id=1002 or vend_id=1003
B.select * from products where vend_id in(1002,1003);
C.select * from products where vend_id not in(1004,1005);
D.select * from products where vend_id=1002and vend_id=1003