数据库中有一张表名称为Student,有列Number,Name,Age,IDCard,Sex。主键为Number。要求查询所有男同学信息,下列哪个SQL语句是正确的?()
A. Select* From Student Where Sex=’男’
B. Select* From Student Where Number NotIn(Select Number From Student Where Sex<>=’男’)
C. Select* From Student Where NumberIn(Select Numbe rFrom Student Where Sex=’男’)
D. Select* From Student Where Sex<>’男&rsquo