一个SQL语句,帮我检查一下错误,谢谢!!

[wwgddx]

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附近有错误!!谢谢啊!@

[hyrongg]

SELECT Gateway, Company,COUNT (*) AS SendNum,
COUNT(DISTINCT Mobile) AS UserNum
FROM Vi_Msg_Count
GROUP BY Gateway, Company
Having Convert(varchar(10),RecvTime,121) = '2007-02-04'

[leo_lesley]

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

[leo_lesley]

where语句 不能在 group by 后面的

[云中客]

好像不是FROM处有错误,而是WHERE处的错误,这样来写:
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的后面

[wwgddx]

好的,谢谢了,我明天试一下,如果还有问题再来,呵呵!

[marco08]

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

[萧霖]

用order by

[hosts]

SELECT Gateway, Company,COUNT (*) AS SendNum,
COUNT(DISTINCT Mobile) AS UserNum FROM Vi_Msg_Count GROUP BY Gateway,
Company having Convert(varchar(10),RecvTime,121) = '2007-02-04'

[wwgddx]

我还想知道这个语句里面 AS的作用是什么? 以前没用过AS

还有Convert(varchar(10),RecvTime,121) = '2007-02-04' 这个的意思是什么,转换类型?? 121是什么?

谢谢了

[marco08]

AS 是給結果取個別名

[dawugui]

SELECT Gateway, Company,COUNT (*) AS SendNum, COUNT(DISTINCT Mobile) AS UserNum
FROM Vi_Msg_Count
where Convert(varchar(10),RecvTime,120) = '2007-02-04'
GROUP BY Gateway, Company

[marco08]

Convert(varchar(10),RecvTime,121)

--
日期類型轉換成字符型

[中国风]

where Convert(varchar(10),RecvTime,121) = '2007-02-04'
要放在group by 前面

[kourr2004]

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'
--呵呵，上面都说写过了，就不写了，楼主主要是把where 位置放错了，
where Convert(varchar(10),RecvTime,121) = '2007-02-04'
应该放到GROUP BY Gateway, Company前面，GROUP BY Gateway, Company 后面是用having

[wwgddx]

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
谢谢大家的帮忙，关于这条语句，我想再问个问题，这条语句查出的数据，有相同字段名称的不同数值我想让它挨着排序，该使用什么语句。有朋友能帮忙解说一下吗？谢谢

[wwgddx]

SELECT Gateway, Company,COUNT (*) AS SendNum, COUNT(DISTINCT Mobile) AS UserNum FROM Vi_Msg_Count where Convert(varchar(10),RecvTime,121) = '2007-02-05' GROUP BY Gateway, Company ORDER BY Company DESC
想统计出某个地区的某两天的每天信息总量，按日期进行排序该如何更改呢？

[wwgddx]

SELECT Gateway, Company,COUNT (*) AS SendNum,
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之后列举的第一个字段对记录排序。然后对此字段中等值的记录用第二字段列举的值进行排序，依此类推。