题目内容

下面选项中,与“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()

查看答案

下面选项,用于排序的关键字是()

A. GROUP BY
B. ORDER BY
C. HAVING
D. WHERE

查看答案

下面选项中,与“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 * 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;