我只是想选出让模板按访问量排序,那个count我本来想用count(*)的也不让用,我只好count(time) 然后,加上order by 就不行了
https://help.fanruan.com/finereport/doc-view-891.html#5
logdb支持这些关键字,不支持order by,但是写了不会报错
建议使用扩展后排序
扩展后排序-https://help.fanruan.com/finereport/doc-view-897.html
order BY 2 ASC
order by count(time) asc
别名在本查询是不生效的。。子查询的才可以用别名
或者你可以外面套一个查询,然后order by cc
select * FROM (SELECT TNAME, COUNT(time) AS CC FROM FINE_RECORD_EXECUTE GROUP BY TNAME)ORDER BY CC ASC
select tname,cc from
(select tname,count(time) as cc from fine_record_execute group by tname)
order by cc
嵌套一下就可以