Request a Demo
Home   >   mailing lists

Required distinct record with all fields - Mailing list pgsql-admin

From Sunil Jadhav
Subject Required distinct record with all fields
Date
Msg-id CAEQOu1Ed7DCbhqKxpMn4dEqp_VB=n+5zQB+JCZEANkJFoa+gXA@mail.gmail.com
Whole thread Raw
Responses Re: Required distinct record with all fields
List pgsql-admin
Tree view
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 by date:

Previous
From: Kashif Zeeshan
Date:
Subject: Re: pg_basebackup Failed
Next
From: Paul Smith*
Date:
Subject: Re: Required distinct record with all fields