Required distinct record with all fields

Поиск
Список
Период
Сортировка
От Sunil Jadhav
Тема Required distinct record with all fields
Дата
Msg-id CAEQOu1Ed7DCbhqKxpMn4dEqp_VB=n+5zQB+JCZEANkJFoa+gXA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Required distinct record with all fields  (Paul Smith* <paul@pscs.co.uk>)
Список pgsql-admin
Дерево обсуждения
Hello team,

we have table & its having 10 diff columns.

1) we need to fetch distinct records from 1 column

suppose earlier we have 500 records after
distinct we have 150 records only -->> we can used simply distinct function with column name

will get the 150 unique data/records BUT.... based on output means 150 records

2) how we can retrieve all other filed information like how we can achieve through SQL.

Thanks & Regards
Sunil 

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

Предыдущее
От: Kashif Zeeshan
Дата:
Сообщение: Re: pg_basebackup Failed
Следующее
От: Paul Smith*
Дата:
Сообщение: Re: Required distinct record with all fields