SELECT Gateway, Company,COUNT (*) AS SendNum, COUNT(DISTINCT Mobile) AS UserNum FROM Vi_Msg_Count GROUP BY Gateway, Company where Convert(varchar(10),RecvTime,121) = '2007-02-04' 帮我看看有没有什么语法错误啊? 在运行的时候提示FROM附近有错误!!谢谢啊!@
SELECT Gateway, Company,COUNT (*) AS SendNum, COUNT(DISTINCT Mobile) AS UserNum FROM Vi_Msg_Count GROUP BY Gateway, Company where Convert(varchar(10),RecvTime,121) = '2007-02-04' 帮我看看有没有什么语法错误啊? 在运行的时候提示FROM附近有错误!!谢谢啊!@
COUNT(DISTINCT Mobile) AS UserNum
FROM Vi_Msg_Count
GROUP BY Gateway, Company
Having Convert(varchar(10),RecvTime,121) = '2007-02-04'
SELECT Gateway, Company,
COUNT (*) AS SendNum,
COUNT(DISTINCT Mobile) AS UserNum
FROM Vi_Msg_Count
where Convert(varchar(10),RecvTime,121) = '2007-02-04'
GROUP BY Gateway, Company
SELECT Gateway, Company,COUNT (*) AS SendNum, COUNT(DISTINCT Mobile) AS UserNum FROM Vi_Msg_Count where Convert(varchar(10),RecvTime,121) = '2007-02-04' GROUP BY Gateway, Company
不能把WHERE语句写到GROUP BY的后面
FROM Vi_Msg_Count
where Convert(varchar(10),RecvTime,121) = '2007-02-04'
GROUP BY Gateway, Company
FROM Vi_Msg_Count
where Convert(varchar(10),RecvTime,120) = '2007-02-04'
GROUP BY Gateway, Company
日期類型轉換成字符型
要放在group by 前面
--呵呵,上面都说写过了,就不写了,楼主主要是把where 位置放错了,
where Convert(varchar(10),RecvTime,121) = '2007-02-04'
应该放到GROUP BY Gateway, Company前面,GROUP BY Gateway, Company 后面是用having
COUNT (*) AS SendNum,
COUNT(DISTINCT Mobile) AS UserNum
FROM Vi_Msg_Count
where Convert(varchar(10),RecvTime,121) = '2007-02-04'
GROUP BY Gateway, Company
谢谢大家的帮忙,关于这条语句,我想再问个问题,这条语句查出的数据,有相同字段名称的不同数值我想让它挨着排序,该使用什么语句。有朋友能帮忙解说一下吗?谢谢
COUNT(DISTINCT Mobile) AS UserNum FROM Vi_Msg_Count GROUP BY Gateway,
Company having Convert(varchar(10),RecvTime,121) = '2007-02-04'
COUNT(DISTINCT Mobile) AS UserNum FROM Vi_Msg_Count GROUP BY Gateway,
Company having Convert(varchar(10),RecvTime,121) = '2007-02-04'
ORDER BY Gateway DESC,Company不知道这样可不可以?
ORDER BY 子句可包含添加的字段。首先用 ORDER BY之后列举的第一个字段对记录排序。然后对此字段中等值的记录用第二字段列举的值进行排序,依此类推。
想统计出某个地区的某两天的每天信息总量,按日期进行排序该如何更改呢?