在Query中提供解决方案
问题描述：
我想要报告，同时在那个报告中我可以通过1个查询
这里查询包含访问者的详细信息，但我想要总数据数量
表示vis_Id，Vis_name，CompanyName，Visited
这里访问的是count
i want report , in that report simultaneously i can pass 1 query
here the query contains details of visitors but i want total count of data
means vis_Id,Vis_name,CompanyName,Visited
Here visited is count
答
你好
试试这样
Hi
Try like this
SELECT vis_Id,Vis_name,CompanyName, COUNT(Vis_id) 'Visited' FROM VisiterDtls
GROUP BY vis_Id,Vis_name,CompanyName
问候
GVPrabu
Regards
GVPrabu
嗨AnnuBhai，
试试这样....
Hi AnnuBhai,
Try like this....
SELECT vis_app_visitdetails.PVIS_ID ,
vis_app_visitors.VisName ,
vis_app_company.ComName ,
VD.VisitedCount Visited
FROM smarthawkattendance.vis_app_visitors
LEFT JOIN smarthawkattendance.vis_app_company ON (vis_app_visitors.companyID = vis_app_company.companyID)
LEFT JOIN (SELECT PVIS_ID, COUNT(PVIS_ID)VisitedCount FROM smarthawkattendance.vis_app_visitdetails) VD ON (VD.PVIS_ID=vis_app_visitors.PVIS_ID = )
WHERE (vis_app_visitdetails.dtVis_DateTime BETWEEN '2013-02-05 00:00:01' AND '2013-02-05 23:59:59' )
AND (vis_app_visitors.PVIS_ID=V0202130015 and vis_app_visitors.PVIS_ID=V0502130021);
问候，
GVPrabu
Regards,
GVPrabu