/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 vote133 views1 answer
How to know if table in rigt or left in sql
SQL
50 votes202 views4 answers
Sql alter type of column
SQL
5 votes142 views1 answer
Oracle nls instance
SQL
1 vote147 views1 answer
Oracle sql pad left zeros
SQL
-1 vote126 views2 answers
On update cascade
SQL
0 vote129 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote264 views1 answer
Sqlite display data in separated columns
SQL
0 vote127 views1 answer
Oracle last character of string
SQL
0 vote163 views1 answer
Plpgsql create function
SQL
1 vote133 views1 answer
Oracle duration between timestamps
SQL