求一SQL语句。

Fuid分别为7,8,9,10,11...

select * from productt where jibie=0  order by fuid asc

但fuid为8的纪录要排在顶部。 怎么写？

---

select * from productt where jibie=0  order by fuid desc

---

sorry

---

SQL code:
select
*
from
productt
where
jibie=0
order by
case fuid when 8 then 0 else 1 end asc

---

引用

SQL codeselect*from
  producttwhere
  jibie=0orderbycase fuidwhen8then0else1endasc

up

---

是AC数据库。。

报错了

---

ACCESS 只能帮顶了

---

谢谢大家，呵呵。

---

select  * , iif(fuid=8,0,fuid) as ofuid  from
productt

where
  jibie=0  order by
ofuid
试试看

---

SQL code:
select *
from productt
where jibie=0
order by iif(fuid=8,0,fuid)

---

select * from productt
where jibie=0 fuid in (8,select fuid from productt where fuid <> 8)  order by fuid asc

---

select * from productt
where jibie=0 and fuid in (8,select fuid from productt where fuid <> 8)  order by fuid asc

晕， 少了个 and

---

解