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>
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
