共找到 334 与的SQL语句是 相关的结果，耗时13 ms
检索“至少选修课程号为′C1′的学生姓名(SNAME) ”的SQL语句是A．SELECT s.sname FROM s,sc WHERE c.cno=′C1′B．SELECT s.sname FROM s,sc WHERE c.cno=′C1′AND s.sno=sc.snoC．SELECT s.
若要求查找‘李’姓学生的学生号和姓名，正确的SQL语句是A．SELECT S#,SNAME FROM S WHERE SNAME='李%.'B．SELECT S#,SNAME FROM S WHERE SNAME LIKE '李%.'C．SELECT S#,SNAME FROM S WHERE S
“从学生关系S中检索姓′王′的学生学号”的SQL语句是A．SELECT sno FROM sc WHERE sname=′王′B．SELECT sno FROM sc WHERE sname IS LIKE′王%′C．SELECT sno FROM sc WHERE sname LIKE′王%′D
实现“从学生信息表中找出性别为女的学生姓名”的SQL语句是A．SELECT*FROMsB．SELECT*FROM s WHERE sex＝'女'C．SELECT sname FROM s WHERE sex＝'女'D．SELECT*FROM s WHERE grade＝"
“查询选修了3门以上课程的学生的学生号”，正确的SQL语句是A．sELEcT S#FROM SC GROUP BY S#WHERE COUNT(*)>3B．SELECT s#FROM SC GROUP．BY S#HAVING COtJNT(*)>3C．sELECT S#FROM SC ORDER
有学生信息表student，求年龄在20～22岁之间(含20岁和22岁)的学生姓名和年龄的SQL语句是SELECT sname，age FROM studentWHERE age【 】；
有学生信息表student，求年龄在20岁到22岁之间(含20岁和22岁)的学生姓名和年龄的 SQL语句是：SELECT sname, age FROM studentWHERE age ______；
从学生选课信息表中找出无成绩的元组的SQL语句是( )。A．SELECT*FROM sc WHERE grade＝NULLB．SELECT*FROM sc WHERE grade IS"C．SELECT*FROM sc WHERE grade IS NULLD．SELECT*FROM sc WHE
实现“取消用户USER4对学生表STUD中学号(XH)的修改权限”这一功能的SQL语句是( )。A．REVOKE UPDATE (XH) ON TABLE FROM USER4;B．REVOKE UPDATE (XH) ON TABLE STUD FROM PUBLIC ;C．REVOKE UPD
检索“至少选修课程号为'C1'的学生姓名(SNAME)”的SQL语句是A．SELECT s.sname FROM s, sc WHEREC.cno＝'C1'B．SELECT s.sname FROM s, sc WHERE C.cno='C1'AND s.sno＝sC.snoC．SELECT s.
热门搜索：