找考题网-背景图
单项选择题

在学生表S中,查询年龄在19至22岁之间的学生的姓名(NAME)、年龄(AGE)和所在系(DEPT),实现该功能的正确SQL语句是( )。

A.SELBCT NAME, AGE, DEPT FROM S WHERE AGE BETWEEN 19 AND 22
B.SELECT NAME, AGE, DEPT FROM S WHERE AGE BETWEEN 22 AND 19
C.SELECT NAME, AGE, DEPT FROM S WHERE AGE NOT BETWEEN 19 AND 22
D.SELECT NAME,AGE,DEPT FROM S WHERE BETWEEN 19<AGE
热门试题