/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

9 votes369 views1 answer
Mysql check date range
SQL
2 votes365 views1 answer
Mysql last 7 days including today
SQL
3 votes364 views2 answers
Oracle drop column
SQL
7 votes349 views3 answers
Postgre describe table
SQL
0 vote397 views1 answer
Get statis values sql
SQL
1 vote367 views1 answer
Select dba users oracle
SQL
0 vote384 views1 answer
Mysql remove bad character from all fields
SQL
4 votes362 views1 answer
Sql quote in string
SQL
1 vote380 views1 answer
Hackerrank sql test solutions
SQL
3 votes399 views2 answers
Oracle sql first day of month
SQL