• 2022-06-07 问题

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

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

  • 1