举一反三
- 查询语句“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
内容
- 0
在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;
- 1
下面 语句和”select * from student where sex=’男’ && age=20;”语句查询出的结果是一样的。( ) A: select * from student where sex=’男’ or age=20; B: select * from student where sex=’男’ || age=20; C: select * from student where sex=’男’ and age=20; D: select * from student where sex,age in(’男’,20);
- 2
表student中的包含两个字段,整型的id,字符串型的name。只显示表student中name列记录的SQL语句正确的是() A: select name from student B: select * from student C: select from name in student D: select name
- 3
查询学生的姓名、出生年月,最准确的SQL语句是(<br/>)。 A: SELECT<br/>* FROM students B: SELECT<br/>s_name,birthday FROM students C: SELECT<br/>s_name,birthday,phone FROM students D: SELECT<br/>s_name,birthday FROM students ORDER BY birthday
- 4
关于查询中列的别名, 以下()语句是不正确的(选一项) A: Select name as '姓名' from table B: Select name as姓名 from table where id =1 C: Sleect name = 姓名 from table D: Select names姓名 from table