/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 vote208 views2 answers
How to login to mysql as normal user in ubuntu
SQL
8 votes203 views1 answer
Oracle current date plus 1 month
SQL
4 votes207 views2 answers
Error loading MySQLdb module.
SQL
51 votes445 views6 answers
Installing mysql on ubuntu
SQL
0 vote154 views1 answer
Testing sql queries
SQL
0 vote206 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote219 views1 answer
Oracle list partitions
SQL
28 votes193 views4 answers
Mysql delete database
SQL
0 vote188 views1 answer
Postgresql get current user name
SQL
4 votes186 views2 answers
Oracle set date format
SQL