你可能喜欢
单项选择题
A.Sum返回表达式中所有数的总合,因此只能用于数字类型的列
B.Avg返回表达式中所有数的平均值,可以用于数字型和日期型的列
C.Max和Min可以用于字符型的列
D.Count可以用于字符型的列
单项选择题
A.Select email from student where email !=null
B.Select email from student where email not is null
C.Select email from student where email <> null
D.Select email from student where email is not null
多项选择题
A.insert into book (id,title,price) values(1,'java',100)
B.insert into book (title,price) values('java',100)
C.insert into book values ('java',100) 这辆都不可以啊,如果不指定列需要明确的给出空值
D.insert book values('java',100)
单项选择题
A.select * from TABLE_NAME where rowcount=10
B.select TOP 10 * from TABLE_NAME
C.select TOP of 10 * from TABLE_NAME
D.select * from TABLE_NAME where rowcount<=10