Window function to forward fill

-- USE LAG IGNORING NULLS AND GRAB PREVIOUS VALUE. FILTER OPPOSITE DIRECTION TO GET BACK FILL
SELECT  
		DATE,
        GROUP,
        REVENUE
        COALESCE(REVENUE, LAG(REVENUE) IGNORE NULLS OVER (PARTITION BY GROUP order by DATE), LAG(REVENUE) IGNORE NULLS OVER (PARTITION BY GROUP order by DATE DESC)) as FILL_VALUE
FROM _ADS A

Similar codes

3 votes288 views1 answer
How to uninstall microsoft sql server
SQL
0 vote274 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
13 votes282 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote320 views1 answer
Get clob size oracle
SQL
2 votes269 views1 answer
Select sid oracle
SQL
1 vote335 views1 answer
Postgres see sequence current state
SQL
0 vote313 views1 answer
Oracle swap partition
SQL
-1 vote316 views5 answers
Not in sql
SQL
0 vote332 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
3 votes310 views1 answer
Oracle list dates without weekends
SQL