2016年5月4日
DB2 数据库清表语句
摘要： truncate table DWDM2.tablename IMMEDIATE;alter table DWDM1.tablename activate not logged initially with empty table；but which one is... 阅读全文
posted @ 2016-05-04 20:16 yuerspring 阅读(759) 评论(0) 推荐(0)
DB2 数据库之数据打平函数
摘要： select num, listagg(DSCR, ',') WITHIN GROUP(ORDER BY DSCR) as DSCRfrom DWDM2.QUOTE_TEMP where DSCR != 'E0003' group by num with ... 阅读全文
posted @ 2016-05-04 08:16 yuerspring 阅读(507) 评论(0) 推荐(0)