已知有学生信息表student, 其中学生姓名和年龄分布存放在字段name和age中,查询年龄在20岁到22岁之间的学生姓名和年龄的SQL语句是哪个?( )。
选项:
A:DELETE FROM student WHERE age BETWEEN 20 AND 22
B:INSERT name, age FROM student WHERE age IN [20,22]
C:UPDATE student SET name=name, age=age WHERE age BETWEEN 20 AND 22
D:SELECT name, age FROM student WHERE age BETWEEN 20 AND 22
发布时间:2024-05-10 21:36:41