/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

10 votes189 views2 answers
Show tables in schema oracle
SQL
1 vote176 views1 answer
Count mysql server db tables
SQL
0 vote184 views1 answer
Sql server udf performance
SQL
0 vote195 views1 answer
Normalization in database
SQL
0 vote198 views1 answer
Default order by in mysql
SQL
3 votes186 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote188 views1 answer
Oracle concat datetime
SQL
1 vote184 views1 answer
Sql first day quarter
SQL
4 votes184 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote181 views1 answer
Show size of all tables postgres
SQL