你即將離開本站

並前往https://www.appsloveworld.com/postgresql/100/181/get-the-top-n-rows-by-row-count-in-group-by

Get the top N rows by row count in GROUP BY-postgresql

If i understand well you want to get the top N records with biggest count. You can achieve this with a subquery like this (I suppose you are using MySQL or ...

確定！ 回上一頁

查詢 「Postgresql top N」的人也找了：

  1. Postgresql top
    2.
  2. PostgreSQL ROWNUM
    3.
  3. PostgreSQL RANK
    4.
  4. PostgreSQL top 1
    5.
  5. Postgresql group by - limit
    6.
  6. PostgreSQL SELECT
    7.
  7. PostgreSQL DISTINCT
    8.
  8. PostgreSQL ORDER BY
    9.