若要求查找‘李’姓学生的学生号和姓名，正确的SQL语句是A．SELECT S#,SN
题型：单项选择题
问题：
若要求查找‘李’姓学生的学生号和姓名，正确的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 '％李％'
