PostgreSQL: top n entries per item in same table

by 
SELECT *
FROM (
   SELECT uid,
          title, 
          amount, 
          maker, 
          widgets,
          rank() over (partition by maker order by amount desc) as rank
   FROM entry  
) t
WHERE rank <= 3

More Related Contents:

  1. Select first row in each GROUP BY group?
  2. Optimize GROUP BY query to retrieve latest row per user
  3. How to select id with max date group by category in PostgreSQL?
  4. SQL query to get most recent row for each instance of a given key
  5. Optimize groupwise maximum query
  6. Get values from first and last row per group
  7. Get most common value for each value of another column in SQL
  8. Conditional lead/lag function PostgreSQL?
  9. How to return result of a SELECT inside a function in PostgreSQL?
  10. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  11. Possible to perform cross-database queries with PostgreSQL?
  12. Reset auto increment counter in postgres
  13. Optimize query with OFFSET on large table
  14. GROUP BY and aggregate sequential numeric values
  15. Safely rename tables using serial primary key columns
  16. How to use (install) dblink in PostgreSQL?
  17. get JOIN table as array of results with PostgreSQL/NodeJS
  18. How can I send email from PostgreSQL trigger?
  19. Postgres manually alter sequence
  20. What’s the proper index for querying structures in arrays in Postgres jsonb?
  21. Postgres sql insert query syntax error from phpPgAdmin
  22. Combine two columns and add into one new column
  23. Bulk/batch update/upsert in PostgreSQL
  24. Grant privileges for a particular database in PostgreSQL
  25. Timestamp Difference In Hours for PostgreSQL
  26. SQL INSERT without specifying columns. What happens?
  27. Getting results between two dates in PostgreSQL
  28. How to perform a select query in a DO block?
  29. Subtract hours from the now() function
  30. Query for count of distinct values in a rolling date range

Leave a Comment