sql把特定数据排在第一行

select value_column_name as coNameEn, column_name_chn as coNameCh
from yx_yc_deriving_info
where table_name = 'd_pv_box'
order by case when coNameEn = "ac_p" then 0 else coNameEn end

 

posted @ 2023-02-16 14:33  浮笙芸芸  阅读(40)  评论(0)    收藏  举报