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 vote183 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
3 votes191 views2 answers
How to load files in mysql
SQL
0 vote194 views1 answer
Sql server union if table exist
SQL
0 vote177 views1 answer
Sql server split string and insert into table select
SQL
0 vote181 views1 answer
Can't connect to postgresql mac os
SQL
10 votes181 views4 answers
Primary key in sql
SQL
0 vote182 views1 answer
Optimize sql query
SQL
0 vote150 views1 answer
Raven ql select count
SQL
0 vote180 views1 answer
Mysql function variable
SQL
4 votes188 views1 answer
Restart for pg_hba.conf file
SQL