/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

2 votes295 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote269 views2 answers
Temp tables in sql server
SQL
1 vote240 views2 answers
Oracle 18c xe ORA-65096
SQL
6 votes255 views2 answers
Oracle trigger
SQL
22 votes245 views3 answers
SQL CHEATSHEET
SQL
0 vote341 views1 answer
Sql insert exemplo
SQL
0 vote212 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote252 views1 answer
How do you insert boolean to postgresql
SQL
0 vote229 views1 answer
Drop check command
SQL
9 votes222 views4 answers
Mysql show table fields
SQL