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

3 votes145 views3 answers
Mysql declare variable
SQL
0 vote144 views1 answer
Oracle sql add column auto generated value
SQL
0 vote130 views1 answer
Oracle for loop on list
SQL
2 votes131 views1 answer
Oracle run_duration average
SQL
0 vote131 views1 answer
Inner joint
SQL
0 vote205 views1 answer
Connect google bigquery connect using sqirrel
SQL
-1 vote87 views3 answers
Ubuntu install mssql
SQL
3 votes151 views1 answer
Oracle apex message quit website
SQL
0 vote145 views2 answers
Py sqlite if entry exists
SQL
0 vote133 views1 answer
Vowels in sql
SQL