/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

7 votes263 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote270 views1 answer
Mysql 1 hour ago
SQL
0 vote293 views1 answer
Mysql 3 months ago
SQL
0 vote274 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
6 votes256 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
-1 vote266 views3 answers
SQL to LINQ converter
SQL
0 vote266 views1 answer
Restart sql server command line linux
SQL
0 vote261 views1 answer
Retornar apenas o ano mysql date
SQL
1 vote257 views1 answer
How to truncate a table in databse
SQL
0 vote268 views1 answer
Oracle SQL join three tables and group by column
SQL