语句SELECT name,sex,birthday FROM human返回()列。
举一反三
- 查询语句“Select COUNT(*) FROM human”返回( )行。
- 执行语句“SELECT COUNT (*) FROM human”将返回( )行
- 数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求查询所有男同学信息,下列哪个SQL语句是正确的 A: Select * From Student Where Sex '男' B: Select * From Student Where Sex ='女' C: Select * From Student Where Sex In '男' D: Select * From Student Where Sex ='男'
- 查询学生表中,所有学生的学号(sno),姓名(sname),性别(sex),和生日(birthday),下列select语句正确的是 A: SELECTsno, sname, sex, birthday FROMstudent B: SELECT * FROM student C: SELECTsno, sname, birthday FROM student D: SELECTsno, sname, sex FROMstudent
- 数据库中有一张表名称为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