/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 vote301 views1 answer
Sql cmd no truncate
SQL
2 votes280 views1 answer
Brew start postgres manual
SQL
-1 vote303 views1 answer
Select first rows postgresql
SQL
0 vote301 views1 answer
Selecting duplicates
SQL
11 votes280 views2 answers
Oracle all source
SQL
0 vote297 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote295 views2 answers
Uninstall postgresql mac
SQL
1 vote268 views1 answer
How to delete record sql delphi
SQL
13 votes272 views4 answers
Mysql get last row
SQL
0 vote265 views1 answer
Mysql select row with min date
SQL