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 vote221 views1 answer
Copy data from one postgres container to another
SQL
11 votes600 views4 answers
Reset identity column values in sql server
SQL
0 vote223 views1 answer
Sql case sttement with set
SQL
0 vote222 views1 answer
Mysql update table from select on another table
SQL
3 votes209 views3 answers
How to add month in update sql
SQL
1 vote236 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote223 views1 answer
Sql select most frequent value in column
SQL
0 vote206 views1 answer
How to check replication lag in mySQL
SQL
4 votes245 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote222 views1 answer
Oracle procedure teamplate
SQL