switch 的用法SELECT CASE col WHEN 100 THEN '1' WHEN 50 THEN '2' ELSE '3' END FROM table; -- if else 的用法SELECT CASE WHEN col>100 THEN '1' ...
確定! 回上一頁