/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

4 votes149 views4 answers
Sqlite describe table
SQL
0 vote169 views1 answer
Postgres full text search example
SQL
19 votes144 views5 answers
Date between in mysql
SQL
0 vote134 views1 answer
Compare field sql server
SQL
1 vote154 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote176 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
0 vote146 views1 answer
Sql query interview questions githu
SQL
0 vote175 views1 answer
Sql describe
SQL
0 vote169 views1 answer
Create table like sql
SQL
1 vote161 views1 answer
How to set up a trigger in sql
SQL