I have these two select statements joined with a union statement and they return the correct values. I would like to select the minimum of the two values?
from web_OnlinePass_Use wou
inner join web_top_id wti on wti.ind_id = wou.id
inner join Name n on n.ID = wou.id
where wti.top_ID = '16040' and (USE_DATE >= '12/07/2012' and USE_DATE <= '12/06/2013'))
from web_Online_library_Use wolu
inner join web_top_id wti on wti.ind_id = wolu.id
inner join Name n on n.ID = wolu.id
where wti.top_ID = '16040' and (olu_DATE >= '12/07/2012' and olu_DATE <= '12/06/2013'))
need the figure how to nest this union as part of another select min() statement?
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…