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

-1 vote130 views5 answers
Not in sql
SQL
0 vote85 views1 answer
How to see the content of tables in pgadmin
SQL
2 votes146 views1 answer
Oracle drop sequence if exists
SQL
1 vote134 views1 answer
Sql pick random row
SQL
0 vote145 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote138 views1 answer
Dump db only triggers mysql
SQL
12 votes140 views1 answer
Docker run mysql image
SQL
1 vote139 views1 answer
Raise application error in oracle
SQL
0 vote138 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
6 votes136 views1 answer
Oracle pl sql source
SQL