当前位置: X题卡 > 所有题目 > 题目详情

若要求查找姓名中第一个字为'王'的学生号和姓名。下面列出的SQL语句中,哪个(些)是正确的 Ⅰ.SELECT S#,SNAME FROM S WHERE SNAME='王%' Ⅱ.SELECT S...

查看本题答案

你可能感兴趣的试题

SELECT S#,SNAME FROM,S WHERE SNAME='刘%'  SELECT S#,SNAME FROM S WHERE SNAME='刘_'  SELECT S#,SNAME FROM S WHERES NAME LIKE'刘%'  SELECT S#,SNAME FROM S WHERES NAME LIKE'刘'  
SELECT S#,SNAME FROM S WHERE SNAME=“李%”  SELECT S#,SNAME FROM S WHERE SNAME LIKE“李%”  SELECT S#,SNAME FROM S WHERE SNAME LIKE“李_”  SELECT S#,SNAME FROM S WHERE SNAME=“李_”  
SELECT S#,SNAME FROM S WHERE SNAME =‘刘%’  SELECT S#,SNAME FROM S WHERE SNAME =‘刘_’  SELECT S#,SNAME FROM S WHERE SNAME HKE‘刘%’  SELECT S#,SNAME FROM S WHERE SNAME HKE‘刘_’  
SELECT S#,SNAME FROM S WHERE SNAME='刘%'  SELECT S#,SNAME FROM S WHERE SNAME='刘_'  SELECT S#,SNAME FROM S WHERE SNAME LIKE='刘%'  SELECT S#,SNAME FROM S WHERE SNAME='刘_'  
SELECT S#,SNAME FROM S WHERE SNAME='刘%'  SELECT S#,SNAME FROM S WHERE SNAME='刘_'  SELECT S#,SNAME FROM S WHERE SNAME LIKE'刘%'  SELECT S#,SNAME FROM S WHERE SNAME LIKE'刘_'  

热门试题

更多