/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 vote284 views1 answer
How to query without duplicate rows in sql
SQL
0 vote250 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
2 votes262 views1 answer
Anonymous block plsql
SQL
0 vote248 views1 answer
Parsing float to int in mysql
SQL
0 vote276 views1 answer
Php select data from mysql database without column name
SQL
1 vote266 views1 answer
Xampp import sql file command line
SQL
14 votes277 views2 answers
Oracle export trigger ddl
SQL
0 vote291 views1 answer
ACCEPT nome PROMPT on oracle
SQL
2 votes277 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
-1 vote271 views1 answer
Count occurrences sql
SQL