建立信息系统学生的视图是（）
A: CREATE VIEW is_student AS SELECT sno,sname,sage FROM student WHERE sdpt='is';
B: CREATE VIEW is_student SELECT sno,sname,sageFROM WHERE sdpt='is';
C: CREATE VIEW is_student AS select sno,sname,sage FROM WHERE sdpt='is'
D: CREATE VIEW is_student AS SELECT sno,sname,sage WHERE sdpt='is';
A: CREATE VIEW is_student AS SELECT sno,sname,sage FROM student WHERE sdpt='is';
B: CREATE VIEW is_student SELECT sno,sname,sageFROM WHERE sdpt='is';
C: CREATE VIEW is_student AS select sno,sname,sage FROM WHERE sdpt='is'
D: CREATE VIEW is_student AS SELECT sno,sname,sage WHERE sdpt='is';
举一反三
- 查找学生表student中姓名的第二个字为“t”的学生学号sno和姓名sname，下面SQL语句正确的是（）。 A: SELECT sno, sname FROM student WHERE sname='_t%'; B: SELECT sno, sname FROM student WHERE sname LIKE '_t%'; C: SELECT sno, sname FROM student WHERE sname＝'%t_'; D: SELECT sno, sname FROM student WHERE sname LIKE '%t_';
- 在所有学生中查询比计算机系学生平均年龄大的学生姓名，可以使用的查询语句是： A: SELECT Sname FROM Student WHERE Sage > ( SELECT AVG(Sage) FROM Student ); WHERE Sdept = 'CS' B: SELECT Sname FROM Student WHERE Sage > AVG( SELECT Sage FROM Student WHERE Sdept = 'CS' ); C: SELECT Sname FROM Student WHERE Sage > ( SELECT AVG(Sage) FROM Student WHERE Sdept = 'CS' ); D: SELECT Sname FROM Student WHERE AVG(Sage) > ( SELECT Sage FROM Student WHERE Sdept = 'CS' );
- 针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)。要检索学生表中年龄在17至25岁之间（包括17和25）的学生的姓名及年龄，SQL语句正确的是（ ）。 A: Select * From Student Where Sage between 17 and 25 B: Select Sname, Sage From Student Where Sage between 17 and 25 C: Select Sname, Sage From Student Where Sage >= 17 and Sage<= 25 D: Select Sname, Sage From Student Where Sage >= 17 or Sage<= 25
- 在学生选课数据库中，查询选修了课程的学生的学号、姓名，SQL语句可为（ ） A: SELECT DISTINCT Sno, Sname FROM Student, SC WHERE Student.Sno = SC.Sno; B: SELECT Sno, Sname FROM Student, SC WHERE Student.Sno = SC.Sno; C: SELECT DISTINCT Sno, DISTINCT Sname FROM Student WHERE Student.Sno IN (SELECT Sno FROM SC); D: SELECT Sno, Sname FROM Student WHERE Student.Sno IN (SELECT DISTINCT Sno FROM SC);
- 现要利用Student（sno, sname, ssex, sage, sdept）表查询年龄最小的学生的姓名和年龄。下列实现此功能的查询语句正确的是（ ）。 A: SELECT sname, Min( sage ）from student B: SELECT sname ,sage from student where sage=Min( sage ) C: SELECT TOP 1 Sname , Sage From student D: SELECT TOP 1 sname , sage from student order by sage