关于语句SELECT * FROM stu.st WHERE sid=’003’,以下选项的描述中错误的是
举一反三
- 下面选项中,查询stu表中id值不在2和5之间的学生的SQL语句是( )。 A: select * from stu where id != 2,3,4,5; B: select * from stu where id not betwen 5 and 2; C: select * from stu where id not betwen 2 and 5; D: select * from stu where id not in 2,3,4,5;
- 以下创建视图的语句中,正确的是 A: CREATE st_view AS SELECT sid,sname,ssex FROM stu B: CREATE VIEW st_view SELECT sid,sname,ssex FROM stu C: CREATE VIEW st_view AS sid,sname,ssex FROM stu D: CREATE VIEW st_view AS SELECT sid,sname,ssex FROM stu
- 查询名字中有“金”字的同学的情况,应使用语句 A: SELECT * FROM stu WHERE stuname='_金_' B: SELECT * FROM stu WHERE stuname='%金%' C: SELECT * FROM stu WHERE stuname like '_金_' D: SELECT * FROM stu WHERE stuname like '%金%'
- 在学生关系student(sid,sname……)中,student的属性分别表示学号和姓名,若要查询学号为19170201的学生姓名,下列SQL语句正确的是( )。Ⅰ.SELECT sname FROM student WHERE sid LIKE '19170201'Ⅱ.SELECT sname FROM student WHERE sid LIKE= '19170201'Ⅲ.SELECT sname FROM student WHERE sid='19170201' A: Ⅰ、Ⅱ B: Ⅰ、Ⅲ C: Ⅱ、Ⅲ D: Ⅰ、Ⅱ、Ⅲ
- 查询选修了2门课程以上的学生学号（） A: select sid,count(*) from sc group by sid having count(*)>=2 B: select sid,count(*) from sc group by sid where count(*)>=2 C: select sid,count(*) from sc where count(*)>=2 group by sid D: select sid,count(*) from sc group by cid having count(*)>=2