MySQL query database with the highest number of repeat records

The code is as follows	Copy Code
SELECT keyword, COUNT (*) as Count From Article_keyword GROUP by keyword Order BY Count DESC LIMIT 20

This query statement returns 20 records with the most keyword repeat count (count) in the Article_keyword table.

The code is as follows	Copy Code
SELECT DISTINCT Count (*) as Count From Article_keyword GROUP by keyword Order BY Count DESC LIMIT 6

This query statement returns the number of the top 6 in the Article_keyword table for keyword (count). Return a unique record by adding DISTINCT