oracle 选取出现次数最多的前５条数据

SELECT
	*
FROM
	(
		SELECT
			PROJECT_LISTING.MATERIAL,
			COUNT (*) AS "出现次数"
		FROM
			PROJECT_LISTING
		WHERE
			PROJECT_LISTING.MATERIAL IS NOT NULL
		GROUP BY
			PROJECT_LISTING.MATERIAL
		ORDER BY
			COUNT (*) DESC
	) WHERE　ROWNUM <= 5

	ORDER BY
			COUNT (*) DESC　是关键排序

COUNT (*) AS "出现次数"　　这个可以不写，只是为了看的明白

转载于:https://www.cnblogs.com/xiaowangba/p/6314169.html