单项选择题

在Visual FoxPro中，KC表中KH字段为三位，显示KC表中KH数的第二位是2的所有课程的记录。在命令窗口应执行______

A．SELECT * FROM KC WHERE KH LIKE "2%"
B．SELECT * FROM KC WHERE KH LIKE "_2_"
C．SELECT * FROM KC WHERE KH LIKE "%2"
D．以上都不是

<上一题目录下一题>

热门试题

单项选择题

在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

相关试题