/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 vote104 views1 answer
SQL Server modify_timestamp trigger
SQL
1 vote95 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
22 votes104 views3 answers
SQL CHEATSHEET
SQL
0 vote106 views1 answer
Mql5 datetime get hour
SQL
0 vote100 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote100 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote103 views2 answers
How to relationship query two different tables in MySQL
SQL
1 vote107 views1 answer
Sql week commencing date
SQL
0 vote91 views1 answer
How to get initials in sql
SQL
0 vote95 views1 answer
Sql server port 1434
SQL