回答:with a as(select rownum a,case when rownum in (1,5,9,16) then 'Y' else '' end b from dual connect by rownum < 17), t1 as (select a,b,ROWNUM rn from a),t2 as (select * from t1 where b='Y'),t3 as (select t1.rn,max(t2.rn) as rn1 from t1 left join t2 on t1.rn>=t2.rn group by t1.rn)select t1.a,t1.b,t2.a from t1 left join t3 on t1.rn=t3.rnleft join t2 on t2.rn=t3.rn1
回答:类似这样字段用参数表示,数值sum起来,前台字段也通过参数是否为空来进行隐藏
回答:((IsDelete IS NULL ) OR ( IsDelete = 0 )) 这里多了一个括号
回答:select a.* FROM `tb_ pkdf_ ods` a inner join (select mdno,max(check_date) check_date from `tb_ pkdf_ ods` group by mdno) bon a.check_date=b.check_date and a.mdno=b.mdno
回答:HH表示的是12小时制的小时,用HH24
回答:sum(case when B.value2 is null then A.value1else (A.value1+B.value2*C.RATE)*1000 end) as VALUE
回答:URL后面的“&ref_t=design&ref_c=00148350-f1e”是什么意思 - 我的帆软 (fanruan.com)
回答:[图片]
回答:再加个条件,参数不为空
回答:${if( FIND("管委会",fine_role) > 0 ,"select *from ads.dim_hr_employeewhere region_name='总部'limit 100","select *from ads.dim_hr_employeewhere region_name='西安分所'limit 100")}
57
57
40
10