Grouped LIMIT in PostgreSQL: show the first N rows for each group?

by

New solution (PostgreSQL 8.4)

SELECT
  * 
FROM (
  SELECT
    ROW_NUMBER() OVER (PARTITION BY section_id ORDER BY name) AS r,
    t.*
  FROM
    xxx t) x
WHERE
  x.r <= 2;

More Related Contents:

  1. How to concatenate strings of a string field in a PostgreSQL ‘group by’ query?
  2. Does PostgreSQL support “accent insensitive” collations?
  3. PostgreSQL DISTINCT ON with different ORDER BY
  4. PostgreSQL: running count of rows for a query ‘by minute’
  5. Split comma separated column data into additional columns
  6. IN vs ANY operator in PostgreSQL
  7. How to include “zero” / “0” results in COUNT aggregate?
  8. SQL SELECT speed int vs varchar
  9. delete “column does not exist”
  10. How to create a temporary function in PostgreSQL?
  11. Postgres Case Sensitivity
  12. Polymorphism in SQL database tables?
  13. Record returned from function has columns concatenated
  14. INSERT rows into multiple tables in a single query, selecting from an involved table
  15. How to round an average to 2 decimal places in PostgreSQL?
  16. Explain JOIN vs. LEFT JOIN and WHERE condition performance suggestion in more detail
  17. How to find a table having a specific column in postgresql
  18. postgresql: INSERT INTO … (SELECT * …)
  19. PostgreSQL JOIN with array type with array elements order, how to implement?
  20. Trim trailing spaces with PostgreSQL
  21. Return multiple columns and rows from a function PostgreSQL instead of record
  22. Postgres error updating column data
  23. Check whether string is a date Postgresql
  24. SQL LIKE condition to check for integer?
  25. PostgreSQL 9.3: Dynamic pivot table
  26. How to detect query which holds the lock in Postgres?
  27. PostgreSQL how to create a copy of a database or schema?
  28. PostgreSQL: fill NULL values in timeserie query with previous value
  29. Postgres: convert single row to multiple rows (unpivot)
  30. Get most common value for each value of another column in SQL

Leave a Comment