/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 vote188 views1 answer
Sql server select furst day of current year
SQL
0 vote169 views2 answers
Delete the last item in a table sql
SQL
0 vote201 views1 answer
Mysql group by derived column
SQL
0 vote181 views1 answer
Get only first row mysql
SQL
0 vote185 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote195 views1 answer
How to check the port of mysql installation in mac
SQL
7 votes231 views4 answers
Database dump mysql command
SQL
0 vote216 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
0 vote212 views1 answer
How to select even id in sql
SQL
0 vote266 views1 answer
Oracle plsql sleep
SQL