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 vote230 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote197 views1 answer
Oracle list chain steps
SQL
0 vote226 views1 answer
Neo4j command to run script file
SQL
6 votes233 views1 answer
Oracle pl sql source
SQL
25 votes240 views1 answer
How to update an attribute in MySQL
SQL
0 vote208 views1 answer
Mysql workbench primary key
SQL
0 vote273 views2 answers
How to check if a column exists in a SQL Server table?
SQL
1 vote182 views1 answer
Insert into sql
SQL
0 vote238 views1 answer
Trigger vérifier stock
SQL
1 vote222 views2 answers
Install mysqldump ubuntu
SQL