Visual Basic是一种面向____的程序设计语言。
查看答案
在T-SQL语法中,SELECT语句使用关键字( )可以屏蔽重复行。
A. DISTINCT
B. UNION
C. ALL
D. ONLY 1
语句SELECT MAX(Score) FROM SCInfo查询结果的记录数有( )。
A. 1
B. 3
C. 5
D. 9
查询所有目前年龄不到18岁的学生的姓名、所在班级及年龄,正确的命令是( )。
A. SELECT StName, ClName,YEAR(GETDATE())-YEAR(birthdate) age FROM StInfo WHERE age<18
B. SELECT StName,ClName, YEAR(GETDATE())-YEAR(birthdate) FROM StInfo WHERE YEAR(birthdate)<18
C. SELECT StName, ClName, YEAR(GETDATE())-YEAR(birthdate) ageFROM StInfo WHERE YEAR(GETDATE())-YEAR(birthdate)<18
D. SELECT StName,ClName, YEAR(date())-YEAR(birthdate) FROM StInfo WHERE age<18
从SCInfo表中找出无成绩的记录的SQL语句是( )。
A. SELECT * FROM SCInfo WHERE Score=NULL
B. SELECT * FROM SCInfo WHERE Score IS ''
C. SELECT * FROM SCInfo WHERE Score =''
D. SELECT * FROM SCInfo WHERE Score IS NULL