下列选项中,与“SELECT* FROM student WHERE id not between 2 and 5;”等效的 SOL 语句是注: id 的数据类型是整型。
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;
查看答案
已知某数据表有姓名字段,如果查找姓“王”且姓名是两个字的用户,则应该使用
A. LIKE "王%"
B. LIKE "王_"
C. LIKE "王__"
D. LIKE "%王%”
已知用户表 user 有一个姓名字段 username ,若想查询姓名字段包含“海”的用户,则应使用的 SQL 语句是
A. SELECT* FROM user WHERE username ='海’;
B. SELECT * FROM user WHERE usermame LIKE '%海%’;
C. SELECT * FROM user WHERE username LIKE ‘_海_’;
D. SELECT * FROM user WHERE username LIKE '海’;
下列选项中,用于将 student 表按照 gender 字段进行分组查询,并且查询 score 字段值之和小于300的分组的 SQL 语句是
A. SELECT gender , SUM ( score ) FROM student GROUP BY gender HAVING SUM ( score )<300;
B. SELECT gender , SUM ( score ) FROM student GROUP BY gender WHERE SUM ( score )300;
C. SELECT gender , SUM ( score ) FROM student WHERE SUM ( score )<300 GROUP BY gender ;
D. 以上语句都不对
下列选项中,用于统计 test 表的总记录数量的SQL语句是
A. SELECT SUM (*) FROM test ;
B. SELECT MAX (*) FROM test ;
C. SELECT AVG (*) FROM test ;
D. SELECT COUNT (*) FROM test ;
微信支付 
支付宝支付