SQL case when else
时间:2022-03-14 03:40
先占个坑,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 ;
时间:2022-03-14 03:40
先占个坑,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 ;