/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 vote116 views1 answer
Call function in query sql server
SQL
0 vote384 views1 answer
Create pl/sql stored procedure
SQL
13 votes123 views2 answers
Sqlite rename column
SQL
0 vote125 views1 answer
Convert excel into sqllite db using python
SQL
0 vote134 views2 answers
How covert into int in maria db
SQL
0 vote133 views1 answer
Sql on-premises
SQL
0 vote133 views1 answer
Rollback to name in sql
SQL
8 votes122 views2 answers
Mysql get first x characters
SQL
37 votes127 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote139 views1 answer
Count database access django
SQL