SELECT (
#得到大于等于当前数量的个数(排名)
SELECT COUNT(R.A_count ) FROM (
#分组查询后去除count的重复数据
SELECT DISTINCT (COUNT(a.ID)) A_count FROM A a GROUP BY A.FILED_ID ORDER BY A_count DESC
)R WHERE R.A_count >=COUNT(b.ID)
) as _index
FROM B b WHERE b.FILED_ID ="?";
查找资料后的灵感。大佬看个笑话,小白互相学习