oracle 选择最频繁出现之前，５文章数据

SELECT*
FROM(SELECTPROJECT_LISTING.MATERIAL,COUNT (*) AS "出现次数"FROMPROJECT_LISTINGWHEREPROJECT_LISTING.MATERIAL IS NOT NULLGROUP BYPROJECT_LISTING.MATERIALORDER BYCOUNT (*) DESC) WHERE　ROWNUM <= 5

	ORDER BYCOUNT (*) DESC　是关键排序

COUNT (*) AS "出现次数"　　这不能写，只是为了看的清楚

版权声明：本文博主原创文章，博客，未经同意不得转载。