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

0 vote263 views1 answer
Soql more than today
SQL
7 votes265 views1 answer
Postgres base size
SQL
0 vote268 views1 answer
Excute raw query
SQL
2 votes300 views2 answers
Postgresql get table names
SQL
0 vote260 views1 answer
How to remove default in mysql
SQL
1 vote284 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote275 views1 answer
Sql server concat null
SQL
5 votes257 views1 answer
List foreign key oracle
SQL
0 vote320 views2 answers
Sql unique
SQL
0 vote278 views1 answer
SAP Return
SQL