/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

13 votes122 views1 answer
Select count of distinct values sql
SQL
0 vote143 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote123 views1 answer
Get employees if not contains in sql
SQL
14 votes137 views3 answers
Oracle sql limit results
SQL
0 vote123 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote113 views3 answers
Sql parenthetical expression examples
SQL
3 votes118 views2 answers
Search text in all sql server stored procedure
SQL
0 vote131 views1 answer
Alter domain sql
SQL
0 vote112 views1 answer
Postgresql get current user name
SQL
0 vote129 views4 answers
Creating a comment and reply system PHP and MySQL
SQL