按照语句列的顺序，标志为f，I，e，r我想按顺序排序。怎么做？ [英] in order by statement column having flag as f,I,e,r I want to order by as same. how to do?

问题描述

引用：

按语句列的顺序，标志为f，I，e，r我想按顺序排序。怎么做？？

in order by statement column having flag as f,I,e,r I want to order by as same. how to do??

推荐答案

我猜你试图通过包含文本的列进行排序，但是你不希望它按字母顺序排序。您可以通过在ORDER BY子句中使用CASE语句并为每个标志值赋予数值来完成此操作。它看起来像这样，所有其他代码排序到最后：

I'm guessing that you are trying to order by a column that contains text, but you don't want it to sort alphabetically. You can do this by using a CASE statement in the ORDER BY clause and giving each flag value a numeric value. It would look something like this, with all other codes sorting to the end:

ORDER BY (CASE WHEN flag='f' THEN 0 WHEN flag='I' THEN 1 WHEN flag='e' THEN 2 WHEN flag='r' THEN 3 ELSE 99 END)

这篇关于按照语句列的顺序，标志为f，I，e，r我想按顺序排序。怎么做？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！