sql get highest date from 3 tabels

Solutions on MaxInterview for sql get highest date from 3 tabels by the best coders in the world

Search
showing results for - "sql get highest date from 3 tabels"
Angela
28 Jun 2019
1SELECT MAX(MaxDate) FROM (SELECT MAX(TradeDate) AS MaxDate FROM Office.Transactions WHERE BrokerID = 1 AND TradeDate IS NOT NULLUNIONSELECT MAX(EntryDate) AS MaxDate FROM Office.IOI WHERE BrokerID = 1UNIONSELECT MAX(EntryDate) AS MaxDate FROM Office.TradeNotes WHERE BrokerID = 1) AS X
source
similar questions
sql set max value in columnsql select whole row max columnthird highest salary in sql3rd highest salary in sql2nd max salary query in sqlselect minimum value sqldifference between min and max date sqlhow to get max from each department in sqlhow to fetch highest score in minimum time using mysqlsql select second maxsql max value in columnsql min and max in same querysql get latest of 2 datetimeshow to find lowest in sqlsql select max value from multiple rowssql list dates between two datessql select row with max datesql server current date minus 5 yearswhere date 3d max 28date 29 in sqloracle select row max datemysql query to select the highest valuesql display max valuesql select lowest value rowsecond last highest id in sqlmysql select row max datesql where max date
queries leading to this page
sql get highest date from 3 tabels joinsql get highest date from 3 tabels joinsql get highest date from 3 tabels