/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 vote165 views1 answer
Mariadb list tables
SQL
1 vote231 views2 answers
Drop table with constraints
SQL
4 votes335 views1 answer
Oracle table statistics
SQL
8 votes189 views1 answer
How to remove tables from postgresql
SQL
0 vote213 views1 answer
Oserror mysql_config not found virtualenv
SQL
11 votes340 views2 answers
Import mysql dump command line windows
SQL
0 vote221 views1 answer
Insert into using contant values and source table columns with sql
SQL
1 vote208 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
5 votes213 views2 answers
Sql constraint check value in list
SQL
9 votes356 views2 answers
Current date in postgresql minus 1 day
SQL