Answers for "sql get highest date from 3 tabels"

SQL

0

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

Posted by: Guest on June-03-2021

Source

Code answers related to "sql get highest date from 3 tabels"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#