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 vote231 views1 answer
Sql string contains case sensitive
SQL
0 vote258 views1 answer
Psql show db
SQL
17 votes225 views6 answers
Sql current date
SQL
0 vote255 views1 answer
How to know if table in rigt or left in sql
SQL
2 votes248 views1 answer
Oracle to_char number format percentage
SQL
1 vote253 views2 answers
Backup table mssql
SQL
0 vote263 views2 answers
T sql null or empty string
SQL
0 vote241 views1 answer
Sql developer connect to sql server
SQL
0 vote230 views1 answer
How to check default value of column in sql server
SQL
0 vote243 views2 answers
Disadvantages of stored procedures sql
SQL