/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 vote144 views1 answer
What logs are available on RDS MySQL?
SQL
0 vote124 views1 answer
Oracle query archive mode
SQL
0 vote117 views1 answer
Postgresql conectar
SQL
0 vote125 views1 answer
Fill up postgres db
SQL
19 votes126 views2 answers
Mysql add column after another
SQL
6 votes151 views2 answers
WHERE value IS sql
SQL
1 vote157 views1 answer
How to select random rows from a table
SQL
2 votes131 views1 answer
Oracle index size
SQL
0 vote136 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
8 votes116 views1 answer
Sql remove characters from string right
SQL