Get values from first and last row per group

Get values from first and last row per group

sql postgresql group-by aggregate greatest-n-per-group

postgresql

Performance of max() vs ORDER BY DESC + LIMIT 1

sql postgresql max aggregate sql-limit

postgresql

Aggregate difference between DateTime fields in Django

django sqlite postgresql orm aggregate

postgresql

GROUP BY consecutive dates delimited by gaps

sql postgresql aggregate window-functions

postgresql

Nested aggregate functions with grouping in postgresql

sql postgresql grouping aggregate

postgresql

Concatenate JSON arrays in PostgreSQL aggregate

sql json postgresql aggregate jsonb

postgresql

Fastest way to PostgreSQL Distinct and Format

sql postgresql distinct aggregate postgresql-performance

postgresql

Use something like TOP with GROUP BY

sql postgresql aggregate greatest-n-per-group

postgresql

Create array in SELECT

sql postgresql aggregate aggregate-functions postgresql-9.1

postgresql

PostgreSQL getting daily, weekly, and monthly averages of the occurrences of an event in one query

sql postgresql query-optimization aggregate analytics

postgresql

Build JSON from 2 aggregated columns in Postgres

json postgresql aggregate aggregate-functions jsonb

postgresql

Crosstab with a large or undefined number of categories

sql postgresql pivot aggregate crosstab

postgresql

Finding all rows with unique combination of two columns

sql ruby-on-rails postgresql duplicates aggregate

postgresql

Get n grouped categories and sum others into one

sql postgresql query-optimization aggregate sql-limit

postgresql

Postgres GROUP BY, then sort

sql postgresql group-by sql-order-by aggregate

postgresql