A: sname=‘刘*’
B: sname=‘%刘%’
C: sname like‘刘%’
D: 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'刘&'
- 若要求查找Student表中，姓名的第二个字为''刘''的学生学号和姓名。下面列出的SQL语句中，哪个是正确的（ ） A: SELECT Sno，SNAME FROM S WHERE SNAME=′_刘%′ B: SELECT Sno，SNAME FROM S WHERE SNAME LIKE′%刘%′ C: SELECT Sno，SNAME FROM S WHERE SNAME LIKE′_刘%′ D: 全部
- 若要求查找Student表中，姓名的第二个字为''刘''的学生学号和姓名。下面列出的SQL语句中，哪个是正确的（ ） A: SELECT Sno，SNAME FROM S WHERE SNAME=′_刘%′ B: SELECT Sno，SNAME FROM S WHERE SNAME LIKE′%刘%′ C: SELECT Sno，SNAME FROM S WHERE SNAME LIKE′_刘%′ D: 全部
- 若要求查找姓名中第一个字为‘刘’的学生号和姓名。下面列出的SQL语句中，（ ）是正确的。 A: SELECT S#，SNAME，FROM S WHERE SNAME=‘刘%’ B: SELECT S#，SNAME，FROM S WHERE SNAME=‘刘-’ C: SELECT S#，SNAME，FROM S WHERE SNAME LIKE‘刘%’ D: SELECT S#，SNAME，FROM S WHERE SNAME LIKE ‘刘-’
- S_T数据库关系图如下:[img=332x128]17e448fc85e997f.jpg[/img]查询与“刘晨”在同一个系学习的学生,要求显示学生学号(Sno)、姓名(Sname)及系别(Sdept)。下列SQL语句正确的是()。 A: SELECT Sno, Sname, Sdept FROM Student WHERE Sdept = (SELECT Sdept FROM Student WHERE Sname = '刘晨'); B: SELECT S1.Sno, S1.Sname , S1.Sdept FROM Student S1 , Student S2 WHERE S1.Sdept = S2.Sdept AND S2.Sname = '刘晨'; C: SELECT Sno, Sname, Sdept FROM Student WHERE Sdept IN (SELECT Sdept FROM Student WHERE Sname = '刘晨'); D: SELECT Sno, Sname, Sdept FROM Student WHERE Sdept LIKE (SELECT Sdept FROM Student WHERE Sname = '刘晨');
内容
- 0
若要求查找姓名中第一个字为“刘”的学生号和姓名。下面列出的SQL语句中， ( )是正确的。 A: SELECT S#,SNAME FROM，S WHERE SNAME='刘%' B: SELECT S#,SNAME FROM S WHERE SNAME='刘_' C: SELECT S#,SNAME FROM S WHERES NAME LIKE'刘％' D: SELECT S#,SNAME FROM S WHERES NAME LIKE'刘'
- 1
查找学生表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_';
- 2
从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 '周_'
- 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 * 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 ‘%李%