L lingmao3 Unregistered / Unconfirmed GUEST, unregistred user! 2010-10-11 #1 select 报告编号 from t_xjtest where 报告编号 in ('J10000621','J10000625','J10000622') 我希望排序是J10000621J10000625J10000622不能update库中某字段,再按那字段排序
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
order by case when 报告编号='J10000621' then 1 when 报告编号='J10000625' then 2 when 报告编号='J10000622' then 3 end
]