select count(MONTH) as nums ,MONTH from FA_POLLING_DETAIL group by MONTH
想求出count数最小的month,请问大神如何可以高效的获取。
我通过下面的方式获得了,但是感觉效率肯定超低
select month from (select count(MONTH) as nums ,MONTH from FA_POLLING_DETAIL group by MONTH) where NUMS = (select min(nums) from (select count(MONTH) as nums ,MONTH from FA_POLLING_DETAIL group by MONTH))