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

62 votes248 views8 answers
Mysql add column
SQL
1 vote183 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote224 views1 answer
Extract sql from query object sqlalchemy
SQL
1 vote247 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
1 vote215 views1 answer
Display total number of tables in mysql
SQL
0 vote220 views1 answer
Concat column value of same user in mysql
SQL
8 votes232 views1 answer
Today minus 15 days postgresql
SQL
0 vote230 views1 answer
Foreign key multiple columns
SQL
1 vote231 views1 answer
Drush sql-dump
SQL
22 votes254 views4 answers
Date format mysql
SQL