Syntax

    1. MySQL [test]> select topn(keyword,10) from keyword_table where date>= '2020-06-01' and date <= '2020-06-19' ;
    2. | topn(`keyword`, 10)                                                                                        |
    3. +------------------------------------------------------------------------------------------------------------+
    5. +------------------------------------------------------------------------------------------------------------+
    7. +------------+-----------------------------------------------------------------------------------------------+
    9. +------------+-----------------------------------------------------------------------------------------------+
    10. | 2020-06-19 | a:11, b:8, c:8, d:7, e:7, f:7, g:7, h:7, i:7, j:7                                             |
    11. | 2020-06-18 | a:10, b:8, c:7, f:7, g:7, i:7, k:7, l:7, m:6, d:6                                             |