<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[HongDanNum1的专栏]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/HongDanNum1</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; HongDanNum1]]></copyright><item><title><![CDATA[sql case when then else]]></title><link>https://blog.csdn.net/HongDanNum1/article/details/40339395</link><guid>https://blog.csdn.net/HongDanNum1/article/details/40339395</guid><author>HongDanNum1</author><pubDate>Tue, 21 Oct 2014 08:54:15 +0800</pubDate><description><![CDATA[Case具有两种格式。简单Case函数和Case搜索函数。
--简单Case函数
CASE sex
         WHEN '1' THEN '男'
         WHEN '2' THEN '女'
ELSE '其他' END
--Case搜索函数
CASE WHEN sex = '1' THEN '男'
         WHEN sex = '2' THEN '女'
ELSE '其他]]></description><category></category></item></channel></rss>