35）若要求查找‘李’姓学生的学生号和姓名，正确的SQL语句是______ 
(A)SELECT S#,SNAME FROM S WHERE SNAME=’李%’ 
(B)SELECT S#,SNAME FROM S WHERE SNAME LIKE ’李%’ 
(C)SELECT S#,SNAME FROM S WHERE SNAME=’%李%’ 
(D)SELECT S#,SNAME FROM S WHERE SNAME LIKE ’%李%’

相關試題

相關試卷