摘要: select *,case t.name when 1 then '男' when 2 then '女' end as sex from tt t结果:一. 控制流程函数1.CASE value WHEN [compare-value] THEN result [WHEN [compare-value] THEN result ...] [ELSE result] END CASE WHEN [condition] THEN result [WHEN [condition] THEN result ...] [ELSE result] END该语句用于在不同情况 阅读全文
posted @ 2013-08-06 13:58 度娘818 阅读(474) 评论(0) 推荐(0) 编辑