/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

1 vote350 views1 answer
Moodle query first user access
SQL
0 vote370 views1 answer
SQL query to verify the size of the table
SQL
0 vote359 views1 answer
Mariadb select limit offset
SQL
0 vote418 views1 answer
Wordpress make wp user in db
SQL
0 vote354 views1 answer
Mysql select field if condition
SQL
8 votes414 views2 answers
Default sql server port
SQL
10 votes334 views3 answers
Sql limit results
SQL
0 vote400 views1 answer
Postgres foreign key multiple columns
SQL
0 vote364 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
0 vote373 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL