/SQL/The differnece between to values in sql

The differnece between to values in sql

SELECT 	
city,
	year,
      population_needing_house,
      LAG(population_needing_house)
      OVER (PARTITION BY city ORDER BY year ) AS previous_year
      population_needing_house - LAG(population_needing_house)
 	OVER (PARTITION BY city ORDER BY year ) AS difference_previous_year
FROM 	housing
ORDER BY city, year

Source: learnsql.com

Similar codes

0 vote151 views1 answer
Désinstaller postgresql linux
SQL
2 votes162 views1 answer
Mysql select default if null
SQL
-1 vote238 views5 answers
Left join sql
SQL
0 vote140 views1 answer
Mysql group rows with same value
SQL
0 vote162 views1 answer
Plsql find location of procedure
SQL
0 vote144 views1 answer
Access refused mysql xampp server
SQL
2 votes142 views1 answer
Oracle cpu per session
SQL
2 votes136 views1 answer
Wait delay in sql server
SQL
0 vote153 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote184 views1 answer
Sql alter column name sql server
SQL