1.select name,code,decode(e.code,'JC','JC',e.id) as temp from if_service_type e
此处的decode函数(Oracle),查询e.code是否为JC,如果是JC即赋给temp值为JC,否则赋e给temp值为e.id
2.select nvl((select amount from if_my_voucher where orderid = t.orderid
and rownum = 1),
'0') as daijinquan from if_server_order t
NVL是Oracle PL/SQL中的一个函数。它的格式是NVL( string1, replace_with)。它的功能是如果string1为NULL,则NVL函数返回replace_with的值,否则返回string1的值,如果两个参数都为NULL ,则返回NULL。
3.SELECT CONCAT (c, d) AS e,
if (a / b k is null, 0.0, (a / b)
) AS result
FROM A
concat(a,b )将a字段和b字段拼接。(mysql)
if()函数,如果a / b 的结果为 null ,赋给result值为0.0 ,否则赋给result值为a / b的结果(mysql)