/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 vote104 views1 answer
Sql fetch next 10 rows pdo
SQL
0 vote106 views1 answer
Dump only data
SQL
1 vote133 views1 answer
Mysql select all and rename one
SQL
1 vote111 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote110 views1 answer
Returning with sqlalchemy
SQL
6 votes119 views3 answers
Sql select last id
SQL
0 vote105 views1 answer
What does leave do in mysql
SQL
0 vote61 views1 answer
Delete all rows from table sqlite
SQL
1 vote94 views1 answer
Tsql random number
SQL
0 vote105 views1 answer
Mysql multiple group by
SQL