/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 vote177 views1 answer
Synapse sql table set pk
SQL
0 vote186 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote158 views2 answers
Connect to mysql server mac terminal
SQL
0 vote174 views2 answers
Sql query print strings and int
SQL
33 votes157 views6 answers
Sql delete
SQL
8 votes164 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote159 views1 answer
Select row with latest date mysql
SQL
0 vote171 views1 answer
T-SQL Create Trigger
SQL
-1 vote190 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote153 views4 answers
User defined function sql
SQL