回答:转换一下,比如数值格式是 3.8(小时)oracle:select ceil(3.8)||'小时'||(3.8-trunc(3.8))*60||'分钟' from dual帆软公式:trunc(3.8)+'小时'+(3.8-trunc(3.8))*60+'分钟'
回答:先按 month week day 排序, 然后 act plan goal 排序 出来就是正常的顺序啊with x as(select 'M' as c_date,'A' as c_type,100 as je from dualunion allselect 'M' as c_date,'B' as c_type,30 as je from dualunion allselect 'M' as c_date,'C' as c_type,70 as je from dualunion allselect 'W' as c_date,'A' as c_type,100 as je from dualunion allselect 'W' as c_date,'B' as c_type,30 as je from dualunion allselect 'W' as c_date,'C' as c_type,70 as je from dualunion allselect 'D' as c_date,'B' as c_type,30 as je from dualunion allselect 'D' as c_date,'C' as c_type,70 as je from dual) selecT * from x order by case when c_date='M' then '01'when c_date='W' then '02'when c_date='D' then '03' end,case when c_type='A' then '01'when c_type='B' then '02'when c_type='C' then '03' end
回答:可以试下这个插件,装完之后可以选择按显示值还是实际值导入,实际值的excel有几位小数就导几位
回答:对应分类有空的值把
回答:1,将三个单元格的内容合并到一个单元格E2内2,然后count本单元格E2内容在整列中出现的次数 count(E2{E2 = $E2})3,加数据校验count值=1,不等于1的行报错重复
回答:在单元格里过滤就可以了,两边都加上对方的关联字段,就是inner join
回答:建议另做一个模板,在数据集里只筛选出需要发送邮件的内容,用于定时任务用
回答:要么把控件格式改成年月日,要么把实际时间格式转换成年月呗
回答:表输入组件点预览不会报错一版都能进表输出看不到你的sql,只能猜测是不是用了 union all ,两边的类型可能不同
回答:人才利润表.zip这个demo直接有模板啊
181
181
34
10