用SQL语句查询出年龄大于19且小于23的男学生信息

2024-11-19 18:27:29
推荐回答(4个)
回答1:

select * from student where age>19 and age<23 and sex='男'

回答2:

select * from student where age in (19,22);

回答3:

select * from student where age>19 and age<23 and sex="男"
注:student为表名

回答4:

select * from student where age between 19 and 22