| Finns det personer där sista slutdatum inte överensstämmer mellan BOFRSORT och BOORT? |
with temp_bofrsort as (
SELECT DDBID,BONR,BOBDAT,BOSDAT,
dense_rank() over(partition by ddbid order by bonr desc) invert_bonr
FROM K137.BOFRSORT
),
temp_boort as (
SELECT DDBID,BONR,BOBDAT,BOSDAT ,
dense_rank() over(partition by ddbid order by bonr desc) invert_bonr
FROM K137.BOORT
)
select count(*)
from temp_boort boort
left join temp_bofrsort bofrsort on bofrsort.ddbid = boort.ddbid
and bofrsort.invert_bonr = 1 and boort.invert_bonr = 1
where bofrsort.bosdat != boort.bosdat
|
0 |
|