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

4 votes286 views2 answers
Mysql delete user if exists
SQL
0 vote278 views1 answer
What is the use of index in mysql table
SQL
0 vote287 views1 answer
Sql character index
SQL
0 vote298 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote267 views1 answer
Time in sql server
SQL
0 vote311 views1 answer
How to check database engine in mysql
SQL
5 votes254 views1 answer
Mongodb vs
SQL
0 vote278 views1 answer
Oracle job schedules
SQL
0 vote290 views1 answer
Executescalar in sql server
SQL
0 vote274 views1 answer
Select max salary from each department in sql
SQL