下面选项中,用于查询student表中id值在1,2,3范围内的记录的SQL语句是A.SELECT * FROM student where id=1,2,3;B.SEL
下面选项中,用于查询student表中id在1~3范围内的记录的SQL语句是() A. SELECT*FROMstudentwhereid=1,2,3 B. SELECT*FROMstudentwhere(id=1,id=2,id=3) C. SELECT*FROMstudentwhereidin(1,2,3) D. SELECT*FROMstudentwhereidin1,2,3 点击查看答案 ...
下面选项中,用于查询users表中id值在1,2,3范围内的记录的SQL语句是( ) A. SELECT * FROM users WHERE id=1,2,3; B. SELECT * FROM users WHERE (id=1,id=2,id=3); C. SELECT * FROM users WHERE id in (1,2,3); D. SELECT * FROM users WHERE id in 1,2,3; 点击查看答案进入小程...
下面选项中,查询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
下面选项中,能够按照grade由高到低显示student表中记录的SQL语句是A、SELECT * FROM student ORDER BY grade;B、SELECT * FROM student ORDER BY grade ASC;C、SELECT * FROM student ORDER BY grade DESC;D、SELECT * FROM student GROUP BY grade DESC;...
百度试题 题目下面选项中,能够更新表student中id值小于4的SQL语句是 A.ALTER TABLE student where id相关知识点: 试题来源: 解析 B 反馈 收藏
阅读下面SQL代码:CREATE TABLE student(id INT(3) PRIMARY KEY AUTO_INCREMENT,name VARCHAR(20) NOT NULL,grade FLOAT,);下面选项中,用于查询表中所有记录信息的SQL语句是 A、SEELCT * FROM student; B、SEELCT id,name FROM student LIMIT 2,3; C、SEELCT id,name,grade FROM student; D、SEELCT id,...
【单选题】下面选项中,能够更新 user 表中数据的 SQL 语句是()A. update into user set id =‘ u001 ’; B. update u
结果1 题目下面选项中,关于SQL语句truncate table user;的作用是解释,正确的是( ) A. 查询user表中的所有数据 B. 与“delete from user;“完全一样 C. 删除user表,并再次创建user表 D. 删除user表 相关知识点: 试题来源: 解析 D 反馈 收藏
百度试题 题目下面选项中,可以清空表数据的SQL语句是 A.deletefromuser;B.dropfromuser;C.truncatetableuser;D.deletefromuserwhere1=1;相关知识点: 试题来源: 解析 ACD 反馈 收藏