• 2021-04-14
    语句SELECT name,sex,birthday FROM human返回()列。
  • 3

    内容

    • 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