查询时操作员错误
SELECT siteapplications.Application, Count(visits.VisitId) AS CountOfVisitId
FROM visits, siteapplications
WHERE visits.SiteApplicationId=siteapplications.ApplicationID and Month([visits.VisitTime)]=month and Year([visits.VisitTime])=year
GROUP BY siteapplications.Application
ORDER BY CountOfVisitId DESC;
我遇到操作员错误,当我单击“确定”时,分组依据会突出显示?
任何人都可以帮忙吗,谢谢大家
SELECT siteapplications.Application, Count(visits.VisitId) AS CountOfVisitId
FROM visits, siteapplications
WHERE visits.SiteApplicationId=siteapplications.ApplicationID and Month([visits.VisitTime)]=month and Year([visits.VisitTime])=year
GROUP BY siteapplications.Application
ORDER BY CountOfVisitId DESC;
I get a operator fault and when I click ok Group by is highlighted??
Can anyone help, thx all
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
你的 paren 关闭已关闭
Your paren closing is off