- 博客(1)
- 资源 (1)
- 问答 (1)
- 收藏
- 关注
oracle合并行记录
表机构如下图: gid snpch qsyzbm zzyzbm 1 567700 20100519001 343210 343213 2 567700 20100519001 343215 343299 3 567695 20100519001 343400 343409 4 567696 20100519001 343410 34349...
2010-05-20 13:24:33 151
linux 学习 初级教程
sSql .append( "select id,hbbh,sfjdm,qfsj,zdjdm," )
.append( " jlsj,zxbq,fjxh,note,")
.append( " to_char(qszxrq,'yyyy-mm-dd') as qszxrq, to_char(zzzxrq,'yyyy-mm-dd') as zzzxrq,qrbz,dw,hkgs,userid,czrq, ")
.append( " case when trunc(sysdate)<qszxrq then '1' ")
.append( " when trunc(sysdate)<=zzzxrq and trunc(sysdate)>=qszxrq then '2' ")
.append( " when trunc(sysdate)> zzzxrq then '3' ")
.append( " else '*' ")
.append( " end as sxbz ,")
.append( " '2' as zxbx ")//默认备选
.append( " from dd_hbxxb a where 1=1 ")
.append( " and not exists (select * ")
.append( " from dd_hbjh b ")
.append( " where a.sfjdm = b.sfjdm ")
.append( " and a.zdjdm = b.zdjdm ")
.append( " and a.id = b.hbid ) ");
2010-03-16
高手进来看看,给点思路
2010-05-19
TA创建的收藏夹 TA关注的收藏夹
TA关注的人