Picking the first of an order in an aggregate query

Поиск
Список
Период
Сортировка
От Robert James
Тема Picking the first of an order in an aggregate query
Дата
Msg-id CAGYyBgi7Jf-=SHDQwnDC6YO+dp_f+sNL6=Ax=5wAwgFhLRhG9w@mail.gmail.com
обсуждение исходный текст
Ответы Re: Picking the first of an order in an aggregate query
Список pgsql-general
I have a query

  SELECT grouping_field, MIN(field_a), MIN(field_b)
  FROM ...
  GROUP BY grouping_field

But, instead of picking the MIN field_a and MIN field_b, I'd like to
pick field_a and field_b from the first record, according to an order
I'll specify.  In pseudo-SQL, it would be something like this:

  SELECT grouping_field, FIRST(field_a), FIRST(field_b)
  FROM ...
  ORDER BY field_c DESC, field_d ASC, myfunc(field_e) ASC
  GROUP BY grouping_field

How can I do that with Postgres?


В списке pgsql-general по дате отправления:

Предыдущее
От: Philipp Kraus
Дата:
Сообщение: Re: rights for schema
Следующее
От: Jack Christensen
Дата:
Сообщение: Re: Picking the first of an order in an aggregate query