On Wednesday, November 19, 2003, at 10:26 AM, Abdul Wahab Dahalan wrote:
>
> How do I write a query so that I can get a result as below
> [ select only a record/s with same kk and kj but different pngk.
> For example here I've 3 records with same kk=01,kj=01 but diff
> pngk=a,b,c
> and 2 records with same kk=01,kj=02 but diff pngk=a,b]
I think you'll want to take a look at using GROUP BY
<http://www.postgresql.org/docs/7.4/static/queries-table-
expressions.html#queries-group>