difference between min and max date sql

Solutions on MaxInterview for difference between min and max date sql by the best coders in the world

Search
showing results for - "difference between min and max date sql"
Noeline
04 Jan 2020
1SELECT
2    T.location,
3    Maxv.Amount - Minv.Amount as difference
4FROM
5(
6    SELECT
7       location,
8       MIN(date) MinDate,
9       MAX(date) MaxDate
10    FROM
11      Tbl A 
12    GROUP BY
13      location
14) T INNER JOIN 
15Tbl Minv ON T.MinDate = Minv.date AND T.location = Minv.location INNER JOIN 
16Tbl Maxv ON T.MaxDate= Maxv.date AND T.location = Maxv.location
17
source
similar questions
sql set max value in columnsql min2nd max salary query in sqlsql select min rowselect minimum value sqlsql select max wherehow to get max from each department in sqldate difference in number of days sql serversql max of two valuesdifference in dates sqlsql max value in columnsql min and max in same querysql alternative to max statementsql select minsql select row with max datesql get highest date from 3 tabelsmin 3asec datediff mssqlwhere date 3d max 28date 29 in sqlfind max number in sqlmin and max salary and name in sqlsql display max valuesql min datetimehow to find max and min salary in sqlmin max sqlt sql select min from two valuessql where max date
queries leading to this page
create a min and max date in sqldifference in max and min value of a column in sqlprice min between max in sqlsql query to get min and maximum datedifference max and min in sql querysql query min and max date give me different date in sql serversql query min and max date give me different datemin max between in sqlsql query min and max date gives me different date in sql serverdifference between max and min sqlsql min max for datedifference between min and max date sql