先占个坑,sql 版本的swith case
SELECT Oldvote,(CASE WHEN Oldvote=1 THEN (SELECT NOW() from dual)WHEN Oldvote=2 THEN 1WHEN Oldvote=0 THEN 3ELSE 3END) as "number"FROM dual ;
本文共 220 字,大约阅读时间需要 1 分钟。
先占个坑,sql 版本的swith case
SELECT Oldvote,(CASE WHEN Oldvote=1 THEN (SELECT NOW() from dual)WHEN Oldvote=2 THEN 1WHEN Oldvote=0 THEN 3ELSE 3END) as "number"FROM dual ;
转载于:https://www.cnblogs.com/keithmoring/p/4156168.html