回答:用一个人员列表进行左连接
回答:end as "按期到达"
回答:你把他的报表拷到你的机器上看一下是不是和你的预览一样,也可能是环境不一样
回答:union all 就可以 给后边的sql加一个不等于条件 不会同时满足 select p.project_id, p.project_name, t.org_id, t.org_name from base_project_t p inner join sys_organization_t t on p.org_id = t.org_id where t.parent_org_id = '132' and t.org_id=(select org_id from sys_user_data_right_v where user_id='${userId}') union all select p.project_id, p.project_name, t.org_id, t.org_name from base_project_t p inner join sys_organization_t t on p.org_id = t.org_id where t.parent_org_id = '132' and t.org_id<>(select org_id from sys_user_data_right_v where user_id='${userId}') order by 3
回答: SELECT a.ID,(SELECT b.姓名 from b WHERE b.ID=SUBSTR(a.id,1,2) )||' '||(SELECT b.姓名 from b WHERE b.ID=SUBSTR(a.id,4,2)) FROM a
回答:select kmxm.姓名,kmxm.科目, nvl(cj.分数, 0) 分数 from (select 科目,姓名 from (select distinct 科目 from (select * from table1 union select * from table2 union select * from table3)) full outer join (select distinct 姓名 from (select * from table1 union select * from table2 union select * from table3)) on 1=1 )kmxm left join (select * from table1 union select * from table2 union select * from table3) cj on cj.科目 = kmxm.科目 and cj.姓名=kmxm.姓名 where kmxm.姓名='张三'
6
6
0
10
没有更多