/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 vote311 views1 answer
Inserting data into different tables at once in oracle sql
SQL
8 votes330 views1 answer
Oracle add datafile to tablespace
SQL
-1 vote336 views1 answer
Pl/sql how to delete a trigger
SQL
3 votes323 views1 answer
Locate sql server
SQL
0 vote316 views1 answer
Oracle array
SQL
22 votes298 views4 answers
Tsql rename table
SQL
0 vote322 views1 answer
Mysql where in maintain order
SQL
22 votes298 views4 answers
Show list of users in mysql
SQL
0 vote284 views1 answer
Sql comparison operators
SQL
0 vote338 views1 answer
Sqlalchemy _in array sqlite
SQL