Get single data from table that has multiple values

Question

I have to join my tables from my database, but it has multiple data (repeating data), this is my query:

select ruper from bsl_ruang b join mr_ranap_dokter d on (b.noregis=d.noregis) where d.dokter = '11111'

and the result like this;

I want to make it look like this:

how can I do that?

Brent · Accepted Answer · 2013-08-14 03:07:04Z

2

Try adding the DISTINCT keyword.

select DISTINCT ruper from bsl_ruang b join mr_ranap_dokter d on (b.noregis=d.noregis) where d.dokter = '11111'

answered Aug 14, 2013 at 3:07

Brent

5983 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gordon Linoff · Accepted Answer · 2013-08-14 03:07:21Z

1

Use select distinct:

select distinct ruper
from bsl_ruang b join
     mr_ranap_dokter d
     on (b.noregis=d.noregis)
where d.dokter = '11111';

answered Aug 14, 2013 at 3:07

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges