/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 vote349 views1 answer
Sql log file inof
SQL
2 votes329 views1 answer
How to insert string variable into sqlite database
SQL
2 votes338 views2 answers
How to check database username and password in postgresql
SQL
3 votes322 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote348 views1 answer
Call object contructor and call methods of object
SQL
0 vote336 views1 answer
Mysql page segment
SQL
0 vote320 views2 answers
Oracle create chain rule
SQL
16 votes328 views3 answers
Jwt secret key generator laravel
SQL
2 votes348 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote406 views1 answer
Mysql get longest string in column
SQL