/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 vote140 views1 answer
Postgresql remove new line from string
SQL
2 votes154 views1 answer
Sql count having
SQL
1 vote130 views1 answer
Customer using hdfc bank sql query
SQL
6 votes171 views5 answers
Oracle list tablespaces
SQL
0 vote129 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote135 views1 answer
Désinstaller postgresql linux
SQL
0 vote125 views1 answer
Running query in redshift
SQL
2 votes124 views1 answer
Oracle create directory
SQL
13 votes140 views1 answer
Views in sql
SQL
10 votes142 views4 answers
Else if mysql
SQL