select语句

<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</p><p>从&nbsp;“员工”&nbsp;表的“姓名”字段中找出名字包含“玛丽”的人，下面哪条select语句正确：（&nbsp; &nbsp;）</p><p>A.&nbsp;Select * from员工&nbsp;where&nbsp;姓名&nbsp;=’_玛丽_’&nbsp;&nbsp;</p><p>B.&nbsp;Select * from员工&nbsp;where&nbsp;姓名&nbsp;=’%玛丽_’C</p><p>C.&nbsp;Select * from员工&nbsp;where&nbsp;姓名&nbsp;like ‘_玛丽%’&nbsp;&nbsp;</p><p>D.&nbsp;Select * from员工&nbsp;where&nbsp;姓名&nbsp;like ‘%玛丽%’</p><p><br ></p>