单项选择题

“找出北京供应商的所有信息”的SELECT语句是

A.SELECT*FROM S WHERE CITY='京'
B.SELECT SNO,SNAME FROM S WHERE CITY='北京'
C.SELECT*FROM S WHERE CITY=北京
D.SELECT SNO,SNAME FROM S WHERE CITY=北京