/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 vote185 views1 answer
Mysql change innodb to myisam
SQL
0 vote163 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote205 views1 answer
Mysql dump for selected row
SQL
0 vote282 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote175 views1 answer
How to drop function in sql
SQL
3 votes170 views4 answers
Show sql server database
SQL
0 vote180 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote216 views2 answers
Sqlalchemy default value for column
SQL
7 votes188 views1 answer
Sql limit decimal places
SQL
0 vote174 views1 answer
Mysql count with two joins
SQL