在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;
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;
举一反三
- 在stud表中返回年龄最小的8位同学的信息，使用（)。 A: A.SELECT * FROM stud ORDER BY birthday DESC LIMIT 8; B: B.SELECT * FROM stud ORDER BY birthday ASC LIMIT 8; C: C.SELECT * FROM stud ORDER BY birthday ASC LIMIT 7; D: D.SELECT * FROM stud ORDER BY birthday DESC LIMIT 7;
- 查询学生的姓名、出生年月,最准确的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
- 在SELECT语句中,与排序有关的关键字是______。 A: ORDER BY B: LIMIT C: DESC D: ASC E: ： ACD F: 、查询1997,1999年出生的同学信息,正确的SELECT语句是______。 G: SELECT * FROM student WHERE YEAR(birthday) NOT IN(1997,1999); H: SELECT * FROM student WHERE YEAR(birthday)=1997 OR YEAR(birthday)=1999; I: SELECT * FROM student WHERE YEAR(birthday) IN(1997,1999); J: SELECT * FROM student WHERE YEAR(birthday) EXISTS(1997,1999);
- 语句SELECT name，sex，birthday FROM human返回（）列。
- 查询在2009年9月出生的学生,最准确的SQL语句是(<br/>)。 A: SELECT<br/>* FROM students WHERE birthday BETWEEN '2009-09-01' AND '2009-09-30' B: SELECT<br/>* FROM students WHERE birthday BETWEEN 2009-09-01 AND 2009-09-30 C: SELECT<br/>* FROM students WHERE birthday BETWEEN '2009-09-01' AND '2009-09-31' D: SELECT<br/>* FROM students WHERE birthday BETWEEN 2009-09-01 AND 2009-09-31