如何显示上个月每小时放置的订单？ [英] How to display orders that were placed per hour of the day for last month?

问题描述

我需要显示上个月每小时每小时放置的所有不同订单。请帮忙！谢谢

I need to display all the distinct orders that were placed per hour of the day for the last month. Please Help! Thanks

SELECT a.PatientAccountID
,b.OrderSubTypeAbbr
,b.CreationTime
 
FROM PatientVisit a with( nolock) 
INNER JOIN Order b with( nolock) 
ON a.PatientVisit_oid=b.PatientVisit_oid
WHERE a. VisitTypeCode ='IP'

AND b.OrderSubTypeAbbr IN ('CT Scan','MRI')
AND b.CreationTime >=DATEADD(m,-1,GETDATE())
ORDER BY a.PatientAccountID

推荐答案

WHERE a. VisitTypeCode ='IP'

AND b.OrderSubTypeAbbr IN ('CT Scan','MRI')

-- to filter by month
AND month(b.CreationTime) >= @month -- ' get month from design  'parameter''

-- to filter by hour
and DATEPART(hour,b.CreationTime) = @hour -- get it from design 'parameter'

ORDER BY a.PatientAccountID

这篇关于如何显示上个月每小时放置的订单？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！