语句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
- 在stud表中返回年龄最小的8位同学的信息,使用( ) A: SELECT * FROM studORDER BY birthday DESCLIMIT 8; B: SELECT * FROM studORDER BY birthday ASCLIMIT 8; C: SELECT * FROM studORDER BY birthday ASCLIMIT 7; D: SELECT * FROM studORDER BY birthday DESCLIMIT 7;