A-A+

查询1997 1999年出生的同学信息正确的SELECT语句是（）。

2019-12-09 18:06:12 网课题库阅读次

问题详情

查询1997，1999年出生的同学信息，正确的SELECT语句是（）。

A．SELECT * FROM student WHERE YEAR(birthday) NOT IN(1997, 1999);

B．SELECT * FROM student WHERE YEAR(birthday)=1997 AND YEAR(birthday)=1999;

C．SELECT * FROM student WHERE YEAR(birthday) IN(1997, 1999);

D．SELECT * FROM student WHERE YEAR(birthday) EXISTS(1997, 1999);

SELECT * FROM student WHERE YEAR(birthday)=1997 OR YEAR(birthday)=1999;?SELECT * FROM student WHERE YEAR(birthday) IN(1997,1999);