摘要: --用case排序 CASE c_id WHEN '15' THEN 1 else 2endselect top 4 c.* from m3_channel c where isnull(c.c_upload_mediaserver,'-1') <> '0' ORDER BY CASE c_id WHEN '15' THEN 1 WHEN '14' THEN 2 WHEN '17' T... 阅读全文