题目内容:
若要求查找姓名中第一个字为‘刘’的学生号和姓名。下面列出的SQL语句中,哪个是正确的?A.SELECT S#,SNAME FROM SWHERE SNAME=′刘%′
B.SELECT S#,SNAME FROM SWHERE SNAME=′刘′
C.SELECTS#,SNAMEFROMSWHERESNAMELIKE=′刘%′
D.SELECTS#,SNAMEFROMSWHERESNAME=′刘′
参考答案:
A.SELECT S#,SNAME FROM SWHERE SNAME=′刘%′
B.SELECT S#,SNAME FROM SWHERE SNAME=′刘′
C.SELECTS#,SNAMEFROMSWHERESNAMELIKE=′刘%′
D.SELECTS#,SNAMEFROMSWHERESNAME=′刘′