SELECT ( CASE WHEN STATUS=1THEN 'yes' ELSE 'no' END ) AS STATUS FROM a
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/228953.html原文链接:https://javaforall.net
【_ 記 】SQL语句实现三目表达式SELECT CASEWHENSTAT 1THEN yes ELSE no END
SELECT ( CASE WHEN STATUS=1THEN 'yes' ELSE 'no' END ) AS STATUS FROM a
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/228953.html原文链接:https://javaforall.net