单项选择题

在SQL Server 2000中，查询表STUDENT1中所有李姓的学生。在查询分析器中应执行______

A．SELECT * FROM STUDENT1 WHERE XM LIKE "李"
B．SELECT * FROM STUDENT1 WHERE XM LIKE "李%"
C．SELECT * FROM STUDENT1 WHERE XM IS "李%"
D．以上都不是

<上一题目录下一题>

热门试题

单项选择题

在SQL Server 2000中，分别统计表STUDENT1中学生不同年龄的人数和总平均分。在查询分析器中执行______

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

单项选择题

以下用来求满足条件的总行数的聚集函数是______

A．SUM(＜＞)
B．AVG(＜＞)
C．COUNT(＜＞)
D．MAX(＜＞)

相关试题