在MySQL中函数体一般都是返回SELECT查询语句（）

A.IN

B.NOT IN

C.BETWEEN

D.NOT BETWEEN

A.WHERE

B.HAVING

C.GROUP BY

D.FROM

A.SELECT 姓名 FROM 成绩表 ORDER BY 数学 DESC LIMIT 1, 3;

B.SELECT 姓名 FROM 成绩表 ORDER BY 数学 DESC LIMIT 1, 2;

C.SELECT 姓名 FROM 成绩表 ORDER BY 数学 DESC LIMIT 0, 3;

D.SELECT 姓名 FROM 成绩表 ORDER BY 数学 DESC LIMIT 0, 2;

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);

A.SELECT S.SNO,SN FROM S,SC,C WHERE CN='数据库' AND S.SNO=SC.SNO AND C.CNO=SC.CNO;

B.SELECT SC.SNO,SN FROM S,C,SC WHERE CN='数据库' AND S.SNO=SC.SNO AND C.CNO=SC.CNO;

C.SELECT SC.SNO,SN FROM S,SC,C WHERE S.SNO=SC.SNO AND C.CNO=SC.CNO AND CN='数据库';

D.SELECT S.SNO,SN FROM (S INNER JOIN SC ON S.SNO=SC.SNO) INNER JOIN C ON SC.CNO=C.CNO WHERE CN='数据库';

A.EXISTS

B.NOT EXISTS

C.ANY

D.IN

A.DISTINCT

B.UNION

C.ALL

D.TOP