MySQL排序特定值置后其他值正序

如下所示:

select * from FD_DictionaryItem where DictionaryID=72 order by DictionaryItemID=-1 ASC,DictionaryItemID;

 

转载地址:

https://blog.csdn.net/imphp/article/details/25302677

posted @ 2021-01-09 16:59  许伟强  阅读(227)  评论(0)    收藏  举报