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