select "ReturnId",count("ReturnId") as COUNT_RETURNID from "ECRSums" group by "ReturnId" order by COUNT_RETURNID;
要查询的字段名 为 Return_Id ,表名ECRSums,目的是查询表 ECRSums 中 哪个ReturnId的记录数最多。
select "ReturnId",count("ReturnId") as COUNT_RETURNID from "ECRSums" group by "ReturnId" order by COUNT_RETURNID;
要查询的字段名 为 Return_Id ,表名ECRSums,目的是查询表 ECRSums 中 哪个ReturnId的记录数最多。