超星 - 综合实训2

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()

查看答案

单选题

下面选项中,用于求出某个字段所有值的平均值的函数是()

A. avg()
B. length()
C. count()
D. total()

查看答案