/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

57 votes528 views6 answers
Mysql alter table add column
SQL
0 vote170 views2 answers
Sql join on comma separated field
SQL
0 vote237 views3 answers
How to find all role in mysql
SQL
0 vote192 views1 answer
Running percentage of total postgres
SQL
0 vote161 views1 answer
Date diff sql
SQL
3 votes190 views2 answers
Sql not contains
SQL
1 vote177 views1 answer
Events mysql
SQL
9 votes166 views3 answers
Mysql get last id
SQL
1 vote156 views1 answer
Use of now() in mysql
SQL
0 vote170 views1 answer
How to use sqlcommand
SQL