具有特定Order By格式的SQL查询 [英] SQL Query with specific Order By format

问题描述

我有一个包含以下值的表

  OperationCode OperationDesc操作订单
重复删除1 
 R& I删除1 
 Ovrh删除1 
 Refn准备1 
重新替换2 
 R& I安装2 
 Ovrh安装2 
 Refn Paint 2 
  

我想写一个查询以获得以下结果顺序。请参阅操作订单列

 操作代码OperationDesc操作订单
重新删除1 
重新更换2 
 ; I Remove 1 
 R& I安装2 
 Ovrh删除1 
 Ovrh安装2 
 Refn Prep 1 
 Refn Paint 2 
  
 
 
 
我使用的是sql server 2005. 
解决方案
 p>  这里是SQLFiddel演示  
 
 
 
下面是您可以尝试的示例查询
  SELECT * FROM temp 
 ORDER BY 
 CASE OperationCode 
 WHEN'Repl'THEN 1 
 WHEN'R& I'THEN 2 
 WHEN'Ovrh'THEN 3 
 WHEN'Refn'THEN 4 
 END，OperationOrder 
  
 
I have a table with following values
    OperationCode   OperationDesc   OperationOrder
    Repl        Remove          1
    R&I         Remove          1
    Ovrh        Remove          1
    Refn        Prep            1
    Repl        Replace         2
    R&I         Install         2
    Ovrh        Install         2
    Refn        Paint           2
I want to write a query to get following result order. See in OperationOrder Column
    OperationCode   OperationDesc   OperationOrder
    Repl            Remove      1
    Repl            Replace     2
    R&I             Remove      1
    R&I             Install     2
    Ovrh            Remove      1
    Ovrh            Install     2
    Refn            Prep        1
    Refn            Paint       2
I am using sql server 2005. 
解决方案
Here is SQLFiddel Demo

Below is the Sample Query Which You can try
SELECT * FROM temp
ORDER BY 
CASE OperationCode 
     WHEN 'Repl' THEN 1
     WHEN 'R&I' THEN 2
     WHEN 'Ovrh' THEN 3
     WHEN 'Refn' THEN 4
END, OperationOrder


                        
这篇关于具有特定Order By格式的SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！