判断语句： SELECT case when l.dict_unique_code=3 then 'atth_img' when l.dict_unique_code=4 then 'qw' else col_name end n ,show_type FROM T_CONFIG_LIST L left join T_CONFIG_DICT D on L.DICT_UNIQUE_CODE = D.UNIQUE_CODE WHERE ((d.code = 'SXXW' and d.sub = '
oracl 和db2 常用语法比较： 1、取前N条记录 Oracle：Select * from TableName where rownum <= N; DB2：Select * from TableName fetch first N rows only; 2、取得系统日期 Oracle：Select sysdate from dual; DB2：Select current timestamp from sysibm.sysdummy1; 3、空值转换 Oracle：Select
