SQL语句如何写才能不会又臭又长

SQL语句怎么写才能不会又臭又长

SQL code

select  case when col1 = 1 then "1"         else when col1 = 2 then "2"         else when col1 = 3 then "3" from table1where  (case when col = 1 then 1        else when col = 2 then 2        else when col = 3 then 3 )> col2

上述sql语句有更加好的写法吗，上面的语句一旦case when ... else when 多了之后，又臭又长

[解决办法]
根据LZ给的例子，select中的case语句肯定是少不了的，要优化也是where语句里的case,如下

SQL code

select * from( select  case when col1 = 1 then "1"          else when col1 = 2 then "2"          else when col1 = 3 then "3" end condi,* from table1)twhere condi>col2 

 

查看更多 下一篇