Re: Need Help

On Fri, Nov 14, 2003 at 09:04:47 +0800, Abdul Wahab Dahalan <wahab@mimos.my> wrote:
> 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?

You could do something like:
select a.kk, a.kj, a.pngk, a.vote, b.star from table a left join   (select '*' star, kk, kj from table group by kk, kj
havingcount(*) > 1) b   on (a.kk = b.kk and a.kj = b.kj);
 

I didn't test this so there might be a syntax problem, but it should make it
clear how to do what you want.