SELECT CASE c.scale WHEN 'D771' THEN 1 ELSE 2 END AS COLUMNNAME FROM sys_vdshanghu s,customer c where s.man='512020003' and s.day='2010-05-27' and s.shanghu=c.id;
1.必须有CASE WHEN THEN END四个关键字,如果多个选项的话WHEN THEN一直重复就行。最后可以用ELSE。
2.在END后面,最好跟上一个别名,这样查看。