sql查询
talbe student(
name varchar(20),
chengji int
)
求一条sql语句查出成绩分别为 60 90 30 的学生?(一条语句)
name varchar(20),
chengji int
)
求一条sql语句查出成绩分别为 60 90 30 的学生?(一条语句)
作者: HappyEverAfter 发布时间: 2011-06-15
SQL code
select * from student where chengji in(60,90,30)
作者: zy112429 发布时间: 2011-06-15
SQL code
select * from student where chengji=60 or chengji=90 or chengji=30
作者: cd731107 发布时间: 2011-06-15
SQL code
select * from student where chengji = any(select 60 union all select 90 union all select 30)
作者: aspwebchh 发布时间: 2011-06-15
SQL code
select name,chengji from student where chengji in(60,90,30)
作者: chuanzhang5687 发布时间: 2011-06-15