sql查询

talbe student(
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