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 vote247 views1 answer
Mysql:5.6 syntax create table
SQL
3 votes270 views2 answers
Sql server current date without time
SQL
5 votes279 views1 answer
Oracle add time to date
SQL
0 vote275 views1 answer
Mysql insert into select transaction c#
SQL
0 vote264 views1 answer
Microsoft sql server python connection
SQL
1 vote263 views1 answer
Backup mysql data only
SQL
2 votes247 views1 answer
Postgresql format date dd/mm/yyyy
SQL
12 votes261 views1 answer
Psql drop column
SQL
2 votes282 views1 answer
Metasploit start postgresql
SQL
2 votes265 views3 answers
Current setting postgres timezone
SQL