人员sql语句

80菜鸟

于 2010-09-06 17:10:34 发布

阅读量129

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： SQL C C++ C#

本文链接：https://blog.youkuaiyun.com/peter20082008/article/details/83705350

数据库专栏收录该内容

20 篇文章

订阅专栏


select count(nvl2(substr(a.t_p_xm,0,instr(a.t_p_xm,'[')-1),
substr(a.t_p_xm,0,instr(a.t_p_xm,'[')-1),a.t_p_xm)) as c, nvl2(substr(a.t_p_xm,0,instr(a.t_p_xm,'[')-1),
substr(a.t_p_xm,0,instr(a.t_p_xm,'[')-1),a.t_p_xm) 
as xm from ysu_fams_taskperson a
left join 
ysu_fams_tasks b 
on a.t_id = b.t_id 
where nvl2(substr(a.t_p_xm,0,instr(a.t_p_xm,'[')-1),
substr(a.t_p_xm,0,instr(a.t_p_xm,'[')-1),a.t_p_xm) in ('郑','张')
and b.t_startdate > to_date('2010-01-01','yyyy-mm-dd') and 
b.t_startdate < to_date('2010-06-30','yyyy-mm-dd') 
group by nvl2(substr(a.t_p_xm,0,instr(a.t_p_xm,'[')-1),
substr(a.t_p_xm,0,instr(a.t_p_xm,'[')-1),a.t_p_xm)