ÇóÒ»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

---

½â