/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

5 votes128 views1 answer
Oracle sysdate - 1 month
SQL
0 vote111 views1 answer
Sql show all users
SQL
1 vote140 views1 answer
Drop column if exists sql server
SQL
0 vote133 views1 answer
Modificar tipo de dato sql server
SQL
0 vote119 views1 answer
Hibernate show sql xml property
SQL
0 vote117 views1 answer
Pl sql round
SQL
39 votes183 views4 answers
Select duplicates in sql
SQL
0 vote121 views1 answer
Install squirrel sql ubuntu
SQL
0 vote116 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
9 votes114 views2 answers
Mysql change value
SQL