/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 vote177 views1 answer
How to check if there is no database schema
SQL
0 vote194 views1 answer
Mssql dockere
SQL
0 vote190 views1 answer
Get record which is available in one table but not in another mysql
SQL
21 votes192 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
1 vote178 views1 answer
How to delete record sql delphi
SQL
27 votes226 views5 answers
Mysql set password for user
SQL
0 vote222 views1 answer
Psql store procedure-return multiple table values
SQL
49 votes267 views6 answers
Get duplicate records in sql
SQL
-1 vote190 views3 answers
Psql get last rows
SQL
0 vote189 views2 answers
How to generate a unique random number in mysql
SQL