语句如下:
sql="select email,title,count(email) as totalcount,min(createdate) as firstclickdate from vemailclick where articleid="&articleid&" group by email,title order by createdate desc"
这样的语句会报错
如果我去掉 order by createdate desc就没有错
我现在就是想在此基础上按createdate排序
请问该怎么写
sql="select email,title,count(email) as totalcount,min(createdate) as firstclickdate from vemailclick where articleid="&articleid&" group by email,title order by createdate desc"
这样的语句会报错
如果我去掉 order by createdate desc就没有错
我现在就是想在此基础上按createdate排序
请问该怎么写
sql="select email,title,count(email) as totalcount,min(createdate) as firstclickdate from vemailclick where articleid="&articleid&" group by email,title order by firstclickdate desc"
感谢各位