A: select sname,spec from student
B: select spec,snamefrom student
C: select sname spec from student
举一反三
- 查询姓"张"的学生姓名,下列()语句不能实现。 A: SELECT sname FROM student WHERE left(sname,1)= '张' B: SELECT snameFROM student WHERE sname LIKE '张%' C: SELECT sname FROM student WHERE substring(sname,1,1)= '张' D: SELECT sname FROM student WHERE sname='张%'
- 查找学生表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_';
- 在student（sno，sname，ssex，sage，sdept）表中，查询学生姓名中包含“大”或“小”的学生信息。以下查询语句正确的是（ ）。 A: select * from student where sname in( '_[大小]%') B: select * from student where sname ='%大%' or sname='%小%' C: select * from student where sname like'%大%' or sname like'%小%' D: select * from student where sname like '%[大小]%'
- 对于学生信息表：student(sno，sname，sex，age，dept)，要查询所有刘姓学生的信息，正确的语句是 A: SELECT * FROM student WHERE sname LIKE'刘 * ' B: SELECT * FROM student WHERE sname LIKE'刘 $' C: SELECT * FROM student WHERE sname LIKE'刘%' D: SELECT * FROM student WHERE sname LIKE'刘&'
- 在所有学生中查询比计算机系学生平均年龄大的学生姓名，可以使用的查询语句是： 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' );
内容
- 0
查询姓“李”的学生的所有信息 A: select * from student where sname like ‘#李%’ B: select * from student where sname like ‘%李#’ C: select * from student where sname like “%李%” D: select * from student where sname like ‘%李%
- 1
从Student表检索姓周的学生，对应的SQL语句是( )。 A: Select * From Student Where Sname like '周%' B: Select * From Student Where Sname like '%周' C: Select * From Student Where Sname like '_周' D: Select * From Student Where Sname like '周_'
- 2
对于学生信息表：student(sno，sname，sex，age，dept)，能够得到年龄在20岁至22岁之间的学生的姓名和学号的语句是( )。 A: SELECT*FROM student WHERE age BETWEEN 20 AND 22 B: SELECT sname，sno FROM student WHERE age BETWEEN 20 AND 22 C: SELECT sname，sno FROM student WHERE age>=20 D: SELECT sname，sno FROM student WHERE age<=22
- 3
在student表中显示所有姓马的学生的姓名、生日和Email。下列语句可以实现的（ ） A: select sname,birthdate,email from student where sname like ‘马%’ B: select sname,birthdate,email from student where sname rike ‘马.*’; C: select sname,birthdate,email from student where sname like ‘%马‘ D: select sname,birthdate,email from student where sname =’*马*’
- 4
在所有学生中查询比计算机系所有学生年龄都要大的学生姓名,正确的查询语句是___________________。 A: SELECT Sname FROM Student WHERE Sage > ( SELECT MAX(Sage) FROM Student WHERE Sdept = 'CS'); B: SELECT Sname FROM Student WHERE Sage > ALL ( SELECT Sage FROM Student WHERE Sdept = 'CS'); C: SELECT Sname FROM Student S1 WHERE EXISTS ( SELECT Sage FROM Student S2 WHERE Sdept = 'CS' AND S1.Sage > S2.Sage); D: SELECT Sname FROM Student S1 WHERE NOT EXISTS ( SELECT * FROM Student S2 WHERE Sdept = 'CS' AND S1.Sage <= S2.Sage);