单项选择题

在SQL Server 2000中，在表STUDENT1中统计NL值不同的学生人数。在查询分析器中应执行的命令是______

A．SELECT "统计" AS 类别,COUNT (NL) AS 人数 FROM STUDENT1
B．SELECT "统计" AS 类别,COUNT (ALL NL) AS 人数 FROM STUDENT1
C．SELECT "统计" AS 类别,COUNT (DISTINCT NL) AS 人数 FROM STUDENT1
D．以上都不是

<上一题目录下一题>

热门试题

单项选择题

在Visual FoxPro中，统计KC表中按XF的不同分组各门课程的数量。在命令窗口应执行______

A．SELECT "统计" AS 类别,XF AS学分, COUNT (KH) AS 课程数 FROM KC GROUP BY KH
B．SELECT "统计" AS 类别,XF AS学分, COUNT (KH) AS 课程数 FROM KC GROUP BY XF
C．SELECT "统计" AS 类别,XF AS学分, COUNT (KH) AS 课程数 FROM STU GROUP BY XF
D．以上都不是

单项选择题

在SQL Server 2000中，在表STUDENT中按NL平均值和CJ总分统计查，则SQL语句为______

A．SELECT "统计" AS 类别,MIN (NL) AS 平均年龄,SUM (CJ) AS 总分 FROM STUDENT1
B．SELECT "统计" AS 类别,AVG (NL) AS 平均年龄,SUM (CJ) AS 总分 FROM STUDENT1
C．SELECT "统计" AS 类别,AVG (NL) AS 平均年龄,MAX (CJ) AS 总分 FROM STUDENT1
D．SELECT "统计" AS 类别,COUNT (NL) AS 平均年龄,SUM (CJ) AS 总分 FROM STUDENT1