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

1 vote108 views1 answer
Second last highest id in sql
SQL
0 vote99 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
6 votes109 views2 answers
Mysql interval 1 day
SQL
0 vote94 views1 answer
Query on date sqlite flutter
SQL
0 vote102 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote115 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote101 views1 answer
Postgresql delete type
SQL
0 vote63 views1 answer
Mysql collation for all languages
SQL
0 vote146 views1 answer
Grouping by email domain mysql
SQL
0 vote134 views1 answer
How to get table current identity value in sql server
SQL