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 vote363 views1 answer
How to locate pg_hba.conf file
SQL
8 votes349 views4 answers
Reset SQL auto increment
SQL
0 vote353 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote310 views1 answer
What is between operator
SQL
2 votes324 views1 answer
How to make multiple keys as primary in bdms
SQL
1 vote385 views1 answer
Sql select sum group by id laravel
SQL
2 votes324 views1 answer
While loop sql
SQL
3 votes334 views1 answer
Async await mysql nodejs
SQL
2 votes335 views3 answers
Sql interview query questions
SQL
4 votes328 views5 answers
Primary key
SQL