阅读下面的SQL语句: SELECT DISTINCT name,gender FROM student; 关于此SQL语句的描述,正确的是
举一反三
- 阅读下面的SQL语句: SELECT DISTINCT name,gender FROM student;关于此SQL语句的描述,正确的是(1.0分) A: 查询student表中不重复的name记录 B: 查询时只能消除name字段的重复性 C: 查询时能消除name字段重复性,不能消除gender字段的重复性 D: 查询student表中name和gender记录,并保证没有重复记录
- 查询student表中的gender字段(gender代表性别),使其查询记录中不能出现重复值的SQL语句是(1.0分) A: SELECT gender FROM student; B: SELECT DISTINCT * FROM student; C: SELECT DISTINCT gender FROM student; D: SELECT * FROM student;
- 查询student表中id字段值小于5,并且gender字段值为“女”的学生姓名的SQL语句是() A: SELECT name FROM student WHERE id<;5 OR gender='女'; B: SELECT name FROM student WHERE id<;5 AND gender='女'; C: SELECT name FROM student WHERE id<;5 ,gender='女'; D: SELECT name FROM student WHERE id<;5 AND WHERE gender='女';
- 【单选题】查询student表中id字段值小于5,并且gender字段值为“女”的学生姓名的SQL语句是 A. SELECT name FROM student WHERE id<5 OR gender‘女’; B. SELECT name FROM student WHERE id<5 AND gender=‘女’; C. SELECT name FROM student WHERE id<5 ,gender=‘女’; D. SELECT name FROM student WHERE id<5 AND WHERE gender=‘女’;
- 表student中的包含两个字段,整型的id,字符串型的name。只显示表student中name列记录的SQL语句正确的是() A: select name from student B: select * from student C: select from name in student D: select name