先占个坑，sql 版本的swith case
SELECT Oldvote, (CASE WHEN Oldvote=1 THEN (SELECT NOW() from dual) WHEN Oldvote=2 THEN 1 WHEN Oldvote=0 THEN 3 ELSE 3 END) as "number" FROM dual ;
SQL case when else
原文：http://www.cnblogs.com/keithmoring/p/4156168.html
