/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

1 vote137 views1 answer
How to delete a record from sqlite in android
SQL
0 vote151 views1 answer
Sqlalchemy get ids
SQL
0 vote156 views1 answer
T sql check active deadlock
SQL
5 votes137 views1 answer
List foreign key oracle
SQL
3 votes133 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote161 views1 answer
Mysql utc timestamp
SQL
0 vote108 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
1 vote128 views1 answer
Oracle finding duplicate records
SQL
0 vote143 views1 answer
Sql drop procedure if exists
SQL
1 vote145 views1 answer
Partition by sql server
SQL