SQL 语句的DECODE 和 NVL()函数 SELECT DECODE(WP01.ONDO_KBN,0,'??象外'1,'常温',2,'保冷') AS ONDO_KBN FROM WP01_S_HAITOTAL WP01 //分析: 当 WP01.ONDO_KBN=0 时 ,将 "??象外 "赋值 当 WP01.ONDO_KBN=1 时 ,将 "常温"赋值 当 WP01.ONDO_KBN=2 时 ,将 "...

时间:2024-12-05 21:51栏目:行业资料