单项选择题

若要求查找‘李’姓学生的学生号和姓名,正确的SQL语句是

A.SELECT S#,SNAME FROM SWHERE SNAME‘李%’
B.SELECT S#,SNAME FROM SWHERE SNAME LIKE‘李%’
C.SELECT S#,SNAME FROM SWHERE SNAME=‘%李%’
D.SELECT S#,SNAME FROM SWHERE SNAME LIKE‘%李%’