/SQL/Difference between min and max date sql

Difference between min and max date sql

SELECT
    T.location,
    Maxv.Amount - Minv.Amount as difference
FROM
(
    SELECT
       location,
       MIN(date) MinDate,
       MAX(date) MaxDate
    FROM
      Tbl A 
    GROUP BY
      location
) T INNER JOIN 
Tbl Minv ON T.MinDate = Minv.date AND T.location = Minv.location INNER JOIN 
Tbl Maxv ON T.MaxDate= Maxv.date AND T.location = Maxv.location

Source: stackoverflow.com

Similar codes

0 vote292 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
22 votes273 views4 answers
Show list of users in mysql
SQL
37 votes292 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
1 vote236 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
0 vote311 views1 answer
Joomla execute raw sql
SQL
2 votes282 views1 answer
Oracle run_duration average
SQL
0 vote235 views3 answers
Mysql calculate age from date of birth
SQL
0 vote269 views1 answer
Postgres call view
SQL
1 vote289 views1 answer
Sql current timestamp
SQL
11 votes270 views2 answers
Docker create postgres db
SQL