Re: problem with query and group by error

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: problem with query and group by error
Дата
Msg-id CAOR=d=27CgPwPe4LBVMxR-1d2gBFPgFxbzO41Qd6jRuC2s6diQ@mail.gmail.com
обсуждение исходный текст
Ответ на problem with query and group by error  (Susan Cassidy <susan.cassidy@decisionsciencescorp.com>)
Ответы Re: problem with query and group by error  (Susan Cassidy <susan.cassidy@decisionsciencescorp.com>)
Список pgsql-general
On Fri, Feb 21, 2014 at 10:40 AM, Susan Cassidy
<susan.cassidy@decisionsciencescorp.com> wrote:
>
> I originally had the query without the group by, but I had duplicate rows,
> so I added a group by to eliminate them.


Have you tried select distinct or select distinct on ()?


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

Предыдущее
От: Emanuel Calvo
Дата:
Сообщение: Re: problem with query and group by error
Следующее
От: Susan Cassidy
Дата:
Сообщение: Re: problem with query and group by error