在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;
举一反三
- 查询学生的姓名、出生年月,最准确的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
- 查询学生表中，所有学生的学号（sno），姓名（sname），性别（sex），和生日（birthday），下列select语句正确的是 A: SELECTsno, sname, sex, birthday FROMstudent B: SELECT * FROM student C: SELECTsno, sname, birthday FROM student D: SELECTsno, sname, sex FROMstudent