/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 vote215 views1 answer
Oracle user last connection date
SQL
2 votes226 views2 answers
Install postgresql
SQL
6 votes269 views2 answers
How to get last element sql
SQL
0 vote211 views1 answer
Alter table myisam to innodb
SQL
0 vote272 views1 answer
Reindexing all tables sql server
SQL
1 vote208 views1 answer
Nested if in mysql
SQL
-1 vote214 views1 answer
Mysql coalesce
SQL
24 votes225 views6 answers
Rename a column in sql server
SQL
0 vote217 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote215 views5 answers
Sql table intermédiaire
SQL