下面选项中,用于判断某个字段的值不在指定集合中,可使用()进行判断。
A. OR关键字
B. NO IN关键字
C. IN关键字
D. NOT IN关键字
查看答案
下面选项中,查询student表中id值不在2和5之间的学生,其中正确的SQL语句是()
A. SELECT * FROM student where id!=2,3,4,5;
B. SELECT * FROM student where id not between 5 and 2;
C. SELECT * FROM student where id not between 2 and 5;
D. SELECT * FROM student where id not in 2,3,4,5;
下面选项中,与“SELECT * FROM student where id not between 2 and 5;”等效的SQL是()
A. SELECT * FROM student where id!=2,3,4,5;
B. SELECT * FROM student where id not between 5 and 2;
C. SELECT * FROM student where id not in (2,3,4,5);
D. SELECT * FROM student where id not in 2,3,4,5;
查询student表中id字段值小于5,并且gender字段值为“女”的学生姓名的SQL语句是()
A. SELECT name FROM student WHERE id<5 OR gender='女';
B. SELECT name FROM student WHERE id<5 AND gender='女';
C. SELECT name FROM student WHERE id<5 ,gender='女';
D. SELECT name FROM student WHERE id<5 AND WHERE gender='女';
下面选项中,用于求出表中某个字段所有值的总和的函数是()
A. avg()
B. sum()
C. count()
D. total()
微信支付 
支付宝支付