問題詳情

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 ’%李%’

參考答案

答案：B
難度：適中0.5
統計：A(0),B(0),C(0),D(0),E(0)