/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 vote343 views1 answer
Sql server cannot create database diagram
SQL
25 votes365 views5 answers
Date in mysql
SQL
2 votes332 views1 answer
Oracle table size
SQL
1 vote286 views1 answer
Ms sql - add one hour to time
SQL
1 vote354 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
1 vote354 views1 answer
Backup mysql data only
SQL
0 vote369 views1 answer
Sql quary intervewi question
SQL
5 votes344 views3 answers
Select tables from mysql database
SQL
3 votes345 views2 answers
Brew start mysql
SQL
0 vote387 views2 answers
Mysql dump database tables only
SQL