/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

3 votes175 views1 answer
Oracle user privileges
SQL
0 vote176 views2 answers
Collation in sql
SQL
-1 vote174 views1 answer
Add bool column in sql
SQL
0 vote163 views1 answer
Get server date mysql
SQL
0 vote186 views1 answer
Mysql reset wp_options
SQL
3 votes172 views3 answers
Into in sql
SQL
0 vote171 views1 answer
This week mysql
SQL
0 vote195 views1 answer
Sql get latest of 2 datetimes
SQL
0 vote174 views1 answer
Sql server size of every table in a db
SQL
1 vote148 views1 answer
Can we drop a primary key
SQL