/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

8 votes229 views2 answers
Default sql server port
SQL
0 vote185 views1 answer
How to select a row in sql
SQL
0 vote176 views1 answer
Sql roll up rows into columns
SQL
0 vote169 views1 answer
RowDataPacket
SQL
0 vote194 views2 answers
How to get the date from datetime in mysql
SQL
0 vote250 views1 answer
How to find sql server name
SQL
0 vote198 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote190 views1 answer
Sp in sql server
SQL
0 vote182 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote192 views1 answer
Sql getdate minus 1 day without time
SQL