数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求写SQL语句查询出表中年龄介于20和30岁之间的数据,下列哪个SQL语句是正确的?()
- A、Select* From Student Where Age>=20 ANDAge>=30
- B、Select* From Student Where Age>=20 ANDAge<=30
- C、Select* From Student Where Age BET WENN 20AND30
- D、Select* From Student Where Age>=20&&Age>=30"
正确答案:A,C
答案解析:有

微信扫一扫手机做题