/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

6 votes1.3K views1 answer
Sql select second max
SQL
1 vote164 views1 answer
Sql to mongodb query converter
SQL
3 votes133 views1 answer
Two selects in one query
SQL
0 vote147 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote184 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
2 votes137 views1 answer
Mysql increment value by 1 in update
SQL
0 vote144 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
1 vote139 views1 answer
Python escape mysql
SQL
5 votes147 views3 answers
Bash: mysql: command not found
SQL
0 vote135 views1 answer
Access refused mysql xampp server
SQL