/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 vote269 views1 answer
Show tables in cassandra cql
SQL
2 votes275 views1 answer
Mysql id of inserted row
SQL
0 vote246 views1 answer
Sql server select ignore dupplicates
SQL
0 vote247 views1 answer
Sql select min row
SQL
2 votes274 views1 answer
Dbms transaction (psql)
SQL
-2 votes255 views1 answer
Remove root password mysql
SQL
0 vote222 views1 answer
Get only first row mysql
SQL
0 vote243 views1 answer
If null don't update
SQL
1 vote249 views3 answers
Grant syntax in sql
SQL
0 vote260 views4 answers
Mysql on kubernetes
SQL