Sql get highest date from 3 tabels

SELECT 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: icetips.zendesk.com

Similar codes

5 votes171 views3 answers
Sql server utc to local
SQL
0 vote151 views1 answer
T sql cursor tr
SQL
6 votes155 views2 answers
Can't connect to local mysql server through socket
SQL
5 votes176 views1 answer
Purge undo tablespace usage
SQL
0 vote151 views1 answer
Separator mysql
SQL
0 vote134 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote142 views1 answer
Group by sql not ordering issues
SQL
2 votes248 views1 answer
Mysql create user with remote access
SQL
0 vote139 views1 answer
Sql right characters
SQL
1 vote183 views1 answer
Sql to mongodb query converter
SQL