Sql lag

Sql latlng

For longitudes use: Decimal(9,6), and latitudes use: Decimal(8,6)

Sql lag

	 -- Employee --
------------------------
| 1 | Max | 01.02.2018 |
| 2 | Jon | 15.04.2018 |
| 3 | Eve | 28.06.2018 |
------------------------

SELECT *, 
       Lag(DateColumn, 1) OVER(.ORDER BY DateColumn ASC) AS EndDate
FROM @Employee;

-- Add new column and shift line + 1 of DateColumn
-------------------------------------
| 1 | Mae | 01.02.2018 | NULL		|
| 2 | Jon | 15.04.2018 | 01.02.2018 |
| 3 | Eve | 28.06.2018 | 15.04.2018 |
-------------------------------------

-- See the source for better explanation

Source: sqlshack.com

Similar codes

0 vote284 views1 answer
Ajax error exception handeling
SQL
0 vote270 views1 answer
Learn sqlite dart
SQL
0 vote281 views1 answer
Clear query cache sql server
SQL
23 votes302 views4 answers
How to show all users in mysql
SQL
0 vote293 views1 answer
Pl/pgsql declare variable
SQL
0 vote310 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote286 views1 answer
Radius search with point data in mysql
SQL
5 votes275 views1 answer
Minecraft java port number
SQL
0 vote290 views1 answer
Delete duplicate rows
SQL
1 vote284 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL