查询在2009年9月出生的学生,最准确的SQL语句是(
)。
A: SELECT
* FROM students WHERE birthday BETWEEN '2009-09-01' AND '2009-09-30'
B: SELECT
* FROM students WHERE birthday BETWEEN 2009-09-01 AND 2009-09-30
C: SELECT
* FROM students WHERE birthday BETWEEN '2009-09-01' AND '2009-09-31'
D: SELECT
* FROM students WHERE birthday BETWEEN 2009-09-01 AND 2009-09-31
)。
A: SELECT
* FROM students WHERE birthday BETWEEN '2009-09-01' AND '2009-09-30'
B: SELECT
* FROM students WHERE birthday BETWEEN 2009-09-01 AND 2009-09-30
C: SELECT
* FROM students WHERE birthday BETWEEN '2009-09-01' AND '2009-09-31'
D: SELECT
* FROM students WHERE birthday BETWEEN 2009-09-01 AND 2009-09-31
举一反三
- 查询学生的姓名、出生年月,最准确的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
- 查询姓王的学生信息,最准确的SQL语句是(<br/>)。 A: SELECT<br/>* FROM students WHERE s_name='王' B: SELECT<br/>* FROM students WHERE s_name='王%' C: SELECT<br/>* FROM students WHERE s_name LIKE '王' D: SELECT<br/>* FROM students WHERE s_name LIKE '王%'
- 查询2009年被借过书的图书编号和借书日期，正确的SQL语句是（）。 A: SELECT图书编号，借书日期FROM借阅WHERE借书日期=2009 B: SELECT图书编号，借书日期FROM借阅WHEREyear(借书日期)=2009 C: SELECT图书编号，借书日期FROM借阅WHERE借书日期=year(2009) D: SELECT图书编号，借书日期FROM借阅WHEREyear(借书日期)=year(2009)
- 统计各系男生人数,最准确的SQL语句是(<br/>)。 A: SELECT<br/>COUNT(*) FROM stduents GROUP BY d_no WHERE sex='男' B: SELECT<br/>COUNT(*) FROM students WHERE sex='男'<br/>GROUP BY d_no C: SELECT<br/>COUNT(*) FROM students WHERE sex='男'<br/>ORDER BY d_no D: SELECT<br/>COUNT(*) FROM students HAVING sex='男'<br/>GROUP BY d_no
- 在MySQL中，查看学生表Students表中的姓名Sname属性的SQL语句表达正确的是( )。 A: SELECT * FROM Students B: SELECT * FROM Students WHERE Sname="" C: SELECT Sname FROM Students D: SELECT Sname FROM Students WHERE Sname=""