How to find SUM using sub query in SQL Server?

select websiteId,status,EnquiryDate,sum(countname) as TotalCount
from
(
    SELECT Top 10
        count(d.EnqStatus) as countname,
        d.WebSiteID as websiteId,
d.EnquiryDate as EnquiryDate,
d.EnqStatus as status
    FROM Enquiry as d
    group by d.EnqStatus,d.Name,d.WebSiteID ,d.EnquiryDate
    order by count(d.EnqStatus) desc
)a
group by a.websiteId,a.status ,a.EnquiryDate having a.WebSiteID='1' and EnquiryDate between '2012-04-20 01:57:26.877'  and '2015-04-20 01:57:26.877'  

Share: