New answers tagged


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


Resolve the case with the following command: uncatalog database BD_DBA

Top 50 recent answers are included