/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

1 vote222 views2 answers
Mysql limit offset
SQL
1 vote186 views2 answers
How to enable error squiggles in vs code
SQL
4 votes186 views1 answer
Oracle error line
SQL
0 vote211 views1 answer
Sql today at midnight
SQL
7 votes186 views2 answers
Create mysql user
SQL
12 votes200 views1 answer
Psql drop column
SQL
4 votes185 views6 answers
List all tables in postgres
SQL
0 vote254 views1 answer
Restart serial number for postgres
SQL
13 votes189 views4 answers
What is sql
SQL
0 vote222 views1 answer
Creating sqeuence in oracle database
SQL