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 vote198 views1 answer
Procedures sql insert mysql
SQL
0 vote204 views1 answer
Mysql get first 2 characters of string
SQL
0 vote207 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote193 views1 answer
Kill thread
SQL
0 vote205 views1 answer
Sql server size of every table in a db
SQL
3 votes185 views3 answers
Sql last week
SQL
6 votes190 views2 answers
Mysql get yesterday
SQL
0 vote232 views2 answers
Drop tables from local table database postgres
SQL
0 vote181 views1 answer
Oracle tablespace autoextend
SQL
0 vote140 views1 answer
Sql query with date
SQL