在SELECT语句中使用GROUP BY SNO时，SNO必须()

A.ORDER BY SALARY＞5000

B.GROUP BY SALARY＞5000

C.HAVING SALARY＞5000

D.WHERE SALARY＞5000

A.SELECT Customer,SUM（OrderPrice）from Orders WHERE SUM（OrderPrice）<2000 GROUP BY Customer

B.SELECT Customer,COUNT（OrderPrice）from Orders GROUP BY Customer HAVING COUNT（OrderPrice）<2000

C.SELECT Customer,COUNT（OrderPrice）from Orders HAVING COUNT（OrderPrice）<2000 GROUP BY Customer

D.SELECT Customer,SUM（OrderPrice）from Orders  GROUP BY Customer HAVING SUM（OrderPrice）<2000

A.MySQL UNION 操作符用于连接两个以上的 SELECT 语句的结果组合到一个结果集合中，多个 SELECT 语句会保留重复的数据

B.MYSQL中使用 ORDER BY 子句将查询数据排序后再返回数据

C.MYSQL中使用GROUP BY 语句根据一个或多个列对结果集进行分组

D.MYSQL中使用INNER JOIN(内连接，或等值连接)：获取两个表中字段匹配关系的记录

A.SELECT * FROM Student ORDER BY age;

B.SELECT * FROM Student Group BY 'age';

C.SELECT * FROM Student ORDER BY 'age';

D.SELECT * FROM Student Group BY age;

A.SELECT 性别，COUNT（*） AS 人数 FROM 职工WHERE 工资＜800 ORDER BY 性别

B.SELECT 性别，COUNT（*） AS 人数 FROM 职工WHERE 工资＜800 GROUP BY 性别

C.SELECT 性别，SUM（*） AS 人数 FROM 职工WHERE 工资＜800 GROUP BY 性别

D.SELECT 性别，AVG（*） AS 人数 FROM 职工

A select avg(C) from ABC

B select avg(C) from ABC order by B

C select avg(C) from ABC group by B

D select avg(C) from ABC group by C, B

A.Where

B.Select

C.Join

D.Group

A.求取每个部门的工资的总和

B.求取每个部门中工资的最大数

C.求取每个部门的工资

D.求取每个部门的数据的条数

A.CREATE VIEW V1 AS SELECT Sno， MAX(Grade) FROM SC GROUP BY Sno

B.CREATE VIEW V1 (max_ g) AS SELECT Sno， MAX (Grade) FROM SC GROUP BY Sno

C.CREATE VIEW V1(Sno) AS SELECT Sno， MAX(Grade) FROM SC GROUP BY Sno

D.CREATE VIEW V1(Sno， max_ g) AS SELECT Sno， MAX(Grade) FROM SC GROUP BY Sno

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