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.