问题详情

数据库中有一张表名称为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

时间:2021-12-28 18:27 关键词: 结构化查询语言(SQL) 计算机科学技术

答案解析

A| B