sql查询重复数据且显示出不同数据的重复次数并且排序

SELECT F_Name,count(F_Name) FROM `t_business_person` where F_Lib_ID=000001 GROUP BY F_Name HAVING COUNT(F_Name)>1 ORDER BY COUNT(F_Name);