selecting entire row on which one field is the minimum

Поиск
Список
Период
Сортировка
От edouard.boucher@free.fr
Тема selecting entire row on which one field is the minimum
Дата
Msg-id 20030521011636.GA18831@comploteur.gibbonie.creolie
обсуждение исходный текст
Ответы Re: selecting entire row on which one field is the minimum
Список pgsql-sql
Hi,

i have a table with 2 fields, let's say A and B, both integers.
i would like to select all the A for which the B are minimum

i'm not sure i am clear, so here is an exemple :

A | B
1 | 5
2 | 2
3 | 3
4 | 2
5 | 2

in this situation, the query should return (2, 4, 5)
as it is very easy to ordre a table, i tought this query would be easy
too, but it is more difficult than it looks like.

thanks for help


Edouard Boucher


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: missing chunk number 0 for toast value 32067496
Следующее
От: Benjamin Stewart
Дата:
Сообщение: Functions that return Record Sets