selecting entire row on which one field is the minimum

Поиск
Список
Период
Сортировка
Искать
От
edouard.boucher@free.fr
Тема
selecting entire row on which one field is the minimum
Дата
в 20:39:43
Msg-id
20030521011636.GA18831@comploteur.gibbonie.creolie
Список
Дерево обсуждения
selecting entire row on which one field is the minimum edouard.boucher@free.fr
Re: selecting entire row on which one field is the minimum Rod Taylor <rbt@rbt.ca>
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
Дата:
От: Benjamin Stewart
Дата:
FAQ