| From: | Abdul Wahab Dahalan <wahab(at)mimos(dot)my> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Need Help |
| Date: | 2003-11-14 01:04:47 |
| Message-ID: | 3FB42A2F.20801@mimos.my |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi!
If I've a table like this
kk kj pngk vote
01 02 a 12
01 02 b 10
01 03 c 5
and I want to have a query so that it give me a result as below.
The condition is for each record with the same kk and kj
but difference pngk will be give a mark *;
[In this example for record 1 and record 2 we have same kk=01 and kj=02
but difference pngk a and b so we give * for the mark]
kk kj pngk vote mark
01 02 a 12 *
01 02 b 10 *
01 03 c 5
How should I write the query?
Thanks in advanced.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-11-14 05:11:53 | Re: Need Help |
| Previous Message | Alexander M. Pravking | 2003-11-13 17:42:34 | Re: STRICT function returning a composite type |