【多选题】 徐渭的人物画也很精彩,寥寥数笔,即见精神,有
A. 竹石图轴》
B. 《扁舟雨霁忆雨图》
C. 《驴背吟诗图》
D. 《竹石牡丹图轴》
查看答案
下列聚合函数不忽略空值(NULL)的是()。
A. SUM(列名)
B. MAX(列名)
COUNT(*)
D. AVG(列名)
下面哪个关键字不能影响SELECT 语句返回的结果的行数?()
A. Top n
B. ORDER BY
C. WHERE
D. HAVING
设Students表有三列Number1、Number2、Number3,并且都是整数类型,则以下()查询语句能按照Number2列进行分组,并在每一组中取Number3的平均值。
A. SELECT AVG(Number3) FROM Students
B. SELECT AVG(Number3) FROM Students ORDER BY Number2
C. SELECT AVG(Number3) FROM Students GROUP BY Number2
D. SELECT AVG(Number3) FROM Students GROUP BY Number2,Number3
假设Sales表用于存储销售信息,SName列为销售人员姓名,SMoney列为销售额度,现在要查询每个销售人员的销售次数、销售总金额,则下列()查询语句的执行结果能得到这些信息。
A. SELECT SName, SUM(SMoney), COUNT(SName) FROM Sales GROUP BY SName
B. SELECT SName, SUM(SMoney) FROM Sales
C. SELECT SName, SUM(SMoney) FROM Sales GROUP BY SName ORDER BY SName
D. SELECT SUM(SMoney) FROM Sales GROUP BY SName ORDER BY SName