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

8 votes274 views2 answers
Mysql grant all privileges to user from any host
SQL
1 vote268 views1 answer
Oracle sql first day of year
SQL
2 votes249 views1 answer
How to check grants on a package in oracle
SQL
1 vote243 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
2 votes278 views1 answer
Sql find not in list
SQL
2 votes252 views1 answer
Possgress drop if exists table
SQL
2 votes242 views2 answers
Exec procedure pl sql
SQL
0 vote231 views1 answer
Sqlite3 not commit
SQL
3 votes269 views1 answer
Oracle list user grants
SQL
0 vote288 views1 answer
Oracle pl/sql check if file exists
SQL