/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 vote97 views1 answer
Search db for table name
SQL
0 vote101 views1 answer
What is the use of index in mysql table
SQL
1 vote200 views1 answer
Sql check roles
SQL
0 vote104 views1 answer
Copy data from one postgres container to another
SQL
1 vote92 views1 answer
Jooq convert using gbk
SQL
5 votes111 views1 answer
AND OR NOT operators sql
SQL
0 vote110 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote93 views1 answer
Openquery insert into linked server
SQL
0 vote187 views1 answer
Sqlite woth cmake
SQL
0 vote134 views1 answer
Insert output identity
SQL