/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

5 votes216 views1 answer
Oracle get foreign keys on table
SQL
10 votes317 views4 answers
Sql server pagination
SQL
32 votes218 views6 answers
How to change column name in sql
SQL
0 vote195 views1 answer
Postgresql get current user name
SQL
0 vote215 views1 answer
Postgresql array to rows
SQL
0 vote194 views1 answer
Oracle search columns in schema
SQL
1 vote208 views1 answer
Grab all records from one table to another oracle sql
SQL
1 vote205 views1 answer
Expression number 1 of select list is not in group by clause
SQL
-1 vote198 views1 answer
How to check table exists or not in postgresql
SQL
1 vote207 views1 answer
Oracle duration between timestamps
SQL