查询“学生表t_student”中的前5条记录，字段为学号和姓名。
A: SELECT TOP 5 student_no, student_name
FROM t_student
B: SELECT LIMIT 5 student_no, student_name
FROM t_student
C: SELECT TOP 5 student_no, student_name
FROM
D: SELECT 5 student_no, student_name
FROM t_student
A: SELECT TOP 5 student_no, student_name
FROM t_student
B: SELECT LIMIT 5 student_no, student_name
FROM t_student
C: SELECT TOP 5 student_no, student_name
FROM
D: SELECT 5 student_no, student_name
FROM t_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='女';
- 检索所有姓“张”、姓“田”的学生信息,可以使用的SQL语句有()。 A: SELECT<br/>* FROM student WHERE student_name LIKE('张%'<br/>OR '田%'; B: SELECT<br/>* FROM student WHERE SUBSTRING(student_name,1,1) in('张','田'); C: SELECT<br/>* FROM student WHERE SUBSTRING(student_name,1,1)= '张'<br/>OR SUBSTRING(student_name,1,1)='田'; D: SELECT<br/>* FROM student WHERE student_name LIKE '张%'<br/>OR student_name LIKE '田%';
- 【单选题】查询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
- 若想查询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;