/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 vote227 views1 answer
How to get initials in sql
SQL
1 vote225 views1 answer
Mysql count multiple columns in one query
SQL
2 votes225 views1 answer
Get hour from date sql
SQL
2 votes227 views2 answers
Useradd postgres
SQL
0 vote223 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote219 views1 answer
Order by number of character in sql
SQL
0 vote262 views1 answer
Sql query wordpress export post
SQL
0 vote227 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote220 views1 answer
Postgre admin slow
SQL
1 vote220 views1 answer
Truncate left characters mysql
SQL