sqlÈçºÎÈýá¹ûµ¹¹ýÀ´

±ÈÈçselect * from tb½á¹ûΪ£º

id  name
1    s
5    b
3    c

ÏÖÔÚÒª°Ñ½á¹ûµ¹¹ýÀ´£º

id    name
3      c
5      b
1      s

ÈçºÎʵÏÖ£¿
ÕâÀïûÓÐÈκÎÅÅÐòÒÀ¾Ý¡£

---

??

---

SQL code:
select * from tb order by (case id when 3 then 0
when 5 then 1
when 1 then 2
end) Asc


???

---

SQL code:
--2000ÓÃÁÙʱ±í
select IDENTITY(int,1,1) as rn,* into # from tb
select ID,name from # order by rn desc

---

ƽʱһ°ã¶¼ÊÇÓÃorder by [ÁÐÃû] descÀ´ÊµÏÖµ¹Ðð£¬
µ«ÎÊÌâÊÇÏÖÔÚ²»ÄÜÓÃÈκÎÁÐ×÷ΪÅÅÐòÒÀ¾Ý£¬ÕâÀïµÄtbÖ»ÊǾÙÀý£¬Êµ¼ÊÊÇÒ»¸öÁÙʱ±í¡£

---

ÿÒÀ¾Ý»¹ÔõôÍæ

---

ÒýÓÃ

SQL codeselect ID,namefrom (select*,rn=ROW_NUMBER()over(orderbygetdate())from tb ) zorderby rndesc

up

---

ºÜºÃ£¬ºÜºÃ£¬¶¼²»ÖªµÀÄĸö±È½ÏºÃÁË¡£

---

    ûÒÀ¾Ý»¹Õæ²»ÖªµÀÔõôÍæ  ¹ØעһϠ

---

ÒýÓÃ

ºÜºÃ£¬º