如何按我输入的顺序排序(100)

L

lingmao3

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2010-10-11

• #1

select 报告编号 from t_xjtest where 报告编号 in ('J10000621','J10000625','J10000622') 我希望排序是J10000621J10000625J10000622不能update库中某字段,再按那字段排序

 

Z

zbdzjx

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2010-10-11

• #2

order by case when 报告编号='J10000621' then 1 when 报告编号='J10000625' then 2 when 报告编号='J10000622' then 3 end

 

L

lingmao3

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2010-10-12

• #3

3q,大虾,谢了![]