啊，gahooa太近了：
SELECt * FROM currency_pres ORDER BY CASE WHEN pre='USD' THEN 1 WHEN pre='CAD' THEN 2 WHEN pre='AUD' THEN 3 WHEN pre='BBD' THEN 4 WHEN pre='EUR' THEN 5 WHEN pre='GBP' THEN 6 ELSE 7 END,name;
啊，gahooa太近了：
SELECt * FROM currency_pres ORDER BY CASE WHEN pre='USD' THEN 1 WHEN pre='CAD' THEN 2 WHEN pre='AUD' THEN 3 WHEN pre='BBD' THEN 4 WHEN pre='EUR' THEN 5 WHEN pre='GBP' THEN 6 ELSE 7 END,name;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
