[排序 2个字段]排序问题, 请指教

shrui

两个字段: name和score
及格的(score>=60)和不及格的都按name顺序排序
及格和不及格哪个在前都无所谓, 比如:
a, 65
t, 90
w, 60
b, 45
x, 57
z, 35
这样的查询怎么写? 谢谢!

[ 本帖最后由 yejr 于 2005-12-12 13:15 编辑 ]

snowseya

设置表的别名，然后用union连接及格和不及格两部分，这样是不是就可以了？

snowseya

这样写不知行不行？我没试过啊。你试试吧
(select * from tablename where score> 60 order by name) union (select * from tablename where score< 60 order by name)

snowseya

select * from tablename where score> 60 order by name　 union all  select * from tablename where score< 60 order by name

shrui

原帖由 snowseya 于 2005-12-12 09:13 发表
select * from tablename where score> 60 order by name　 union all  select * from tablename where score< 60 order by name

好像order by 以后再union出问题了(bug?)
看看
(select * from test where score>=60 order by name) union (select * from test where score<60 order by name)
的结果
a=>234
y=>80
s=>66
z=>34
r=>45
h=>12
k=>6