• 2022-05-28
    阅读下面的SQL语句: SELECT DISTINCT name,gender FROM student;关于此SQL语句的描述,正确的是(1.0分)
    A: 查询student表中不重复的name记录
    B: 查询时只能消除name字段的重复性
    C: 查询时能消除name字段重复性,不能消除gender字段的重复性
    D: 查询student表中name和gender记录,并保证没有重复记录
  • D

    内容

    • 0

      阅读下面的SQL语句: SELECT DISTINCT name,gender FROM student; 关于此SQL语句的描述,正确的是

    • 1

      表student中的包含两个字段,整型的id,字符串型的name。只显示表student中name列记录的SQL语句正确的是() A: select name from student B: select * from student C: select from name in student D: select name

    • 2

      若想查询student表中name为空值的记录,则正确的SQL语句是( )。 A: SELECT * FROM student WHERE name = NULL; B: SELECT * FROM student WHERE name like NULL; C: SELECT * FROM student WHERE name = 'NULL'; D: SELECT * FROM student WHERE name is NULL;

    • 3

      若想查询student表中name为空值的记录,则正确的SQL语句是(1.0分) A: select * from student where name = null; B: select * from student where name link null; C: select * from student where name = 'null'; D: select * from student where name is null;

    • 4

      已知 student 表有姓名字段 name ,并且存在 name 为’sun%er’的记录。下列选项中,以匹配“ sun%er ”字段值的 SQL 语句是 A: SELECT * FROM student WHERE name LIKE ‘sun%er’; B: SELECT * FROM student WHERE name LIKE ‘%%%’; C: SELECT * FROM student WHERE name LIKE '%\%%'; D: SELECT * FROM student WHERE name =‘sun%er’;