一个特殊的排序问题

[ppxstar]

字段数据如下
0
0
0
1
0
3
0
2
7
5
0
4
6


如何能做到如下排序
1
2
3
4
5
6
7
0
0
0
0
0
0

[gahade]

declare @t table(id int)
insert into @t(id)
select 0
union all select 0
union all select 0
union all select 1
union all select 0
union all select 3
union all select 0
union all select 2
union all select 7
union all select 5
union all select 0
union all select 4
union all select 6

select id from @t order by case when id=0 then 99999 else id end

[hrb2008]

select col from tb
order by
case col
when 0 then 90
else col
end

[ppxstar]

我sql语句不是很精，看不太懂
上面的数据例子只是显示了一个字段，我的数据库里还有很多其它字段
并且这个字段里的数据还在不段增加。

[ppxstar]

access 是否支持你们的写法呢？？

[gahade]

select id from @t order by case when id=0 then (select max(id)+1 from @t) else id end

[paoluo]

ACCESS中這麼寫

Select * From A Order By IIF(ID = 0, 9999999, ID)

[ppxstar]

我查了一下，access不能用这个语句，只能用iif

但我的语句总是不成功

select *,iif(cost=0,999,cost) from dbname order by cost

这样写不对吗??

[paoluo]

ACCESS這麼寫

Select * From dbname Order By IIF(cost= 0, 9999999, cost)