SQL中IN的排序问题(20分)

L

luket_1979

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-22

• #1

用IN子查询in （1，9，6，10）如何返回按1，9，6，10排序的表

 

3

3h

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-22

• #2

select xxxxx, abc from xxxx where abc in (1,9,6,10) order by abc

 

L

luket_1979

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-22

• #3

order by abc只会按ABC来排序，不会按1，9，6，10的顺序排

 

L

luket_1979

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-22

• #4

UP

 

S

sdhxdjw

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-23

• #5

select * from 销售表 order by case 民
when 1 then 1
when 9 then 2
when 6 then 3
when 10 then 4
end