New answers tagged

1

Why not this? SELECT def.cid, c.dt, LAST_VALUE(b.amount, 'IGNORE NULLS') OVER(PARTITION BY def.cid ORDER BY c.dt) FROM calendar c INNER JOIN (SELECT DISTINCT cid FROM balance1) AS def(cid) ON 1=1 LEFT JOIN balance1 b ON (c.dt, def.cid) = (b.dt, b.cid) ORDER BY c.dt, def.cid ; Comparison in dbfiddle


-1

Resolve the case with the following command: uncatalog database BD_DBA


Top 50 recent answers are included