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 vote253 views1 answer
Mysql get hour from datetime
SQL
0 vote225 views1 answer
Sql server size of every table in a db
SQL
25 votes234 views6 answers
Change column name mysql
SQL
0 vote258 views1 answer
Sql script to remove default from column
SQL
1 vote250 views3 answers
How to pass password to mysql command line
SQL
0 vote202 views1 answer
Opensuse status MySQL
SQL
6 votes234 views1 answer
Oracle list primary key
SQL
0 vote243 views1 answer
Add mysql database to power bi web
SQL
3 votes231 views1 answer
Kill mysql processlist in whose time more than 200
SQL
3 votes242 views1 answer
Get current month last date in sql server
SQL