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 vote346 views1 answer
Cahnge column name apex oracle
SQL
1 vote328 views1 answer
Deleting database in sql
SQL
2 votes360 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote302 views1 answer
Get who is hired in january in sql
SQL
0 vote377 views3 answers
How to find all role in mysql
SQL
0 vote326 views1 answer
Get date ISO in psql
SQL
0 vote302 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote305 views1 answer
Mysql workbench not showing schemas
SQL
0 vote321 views1 answer
Sql menampilkan data tabel
SQL
-1 vote338 views5 answers
Not in sql
SQL