这条语句有错吗?

[yaoying]

sql="SELECT sum(creceived) as sum1 from tLogs where dttime1 like '"&d1&"%' order by sum1 desc"

[huo789]

显然有错啊，order by sum1 desc什么意思，应该是order by creceived desc吧

[hellofox2000]

SELECT sum(creceived) as sum1 from tLogs where dttime1 like '"&d1&"%' gruop by sum1 desc

[wzhiyuan]

sql="SELECT sum(creceived) as sum1 from tLogs where dttime1 like '"&d1&"%' order by sum1 desc"
去掉后面的order by sum1 desc

[sun94510451]

同意 wzhiyuan(我是谁)！

[holoon]

如果不想进行排序的话，就把“order by sum1 desc”去掉。

[holoon]

你前面用“sum(creceived) as sum1”
后面再用“order by sum1 desc”

这里的“sum1”显然，问题出在这里。

[caobin518]

你这种写法应该是对的

[aspme]

sql="SELECT sum(creceived) as sum1 from tLogs where dttime1 like '"&d1&"%' order by sum1 desc"
你想实现的并不是列表形式,所以根本用不上order by sum1 desc
而且order by 后面的条件一定要在数据表中有这个字段才行,如果有的话,那冲突了

[lindy730]

order by sum1 desc
这句错了，sum1在这是不可以用作排序的