Database - Mengenal Berbagai Operator

• Operator BETWEEN dan NOT BETWEEN

select nama, tgl_lahir from infoprib where tgl_lahir between ‘1960-01-01’ and ‘1970-12-31’;

select nama, tgl_lahir from infopribwhere tgl_lahir >= ‘1960-01-01’ and tgl_lahir <= ‘1970-12-31’;

select nama from infoprib where nama between ‘C’ and ‘K’;

select nama from infoprib where nama not between ‘C’ and ‘K’;

select nama from infoprib where not nama between ‘C’ and ‘K’;

• Operator IN dan NOT IN

select nama from infoprib where id_bin = ‘KEVIN’ or id_bin = ‘STONE’ or id_bin = ‘DREWB’;

select nama from infoprib where id_bin in (‘KEVIN’,’STONE’,’DREWB’);

select nama from infoprib where id_bin not in (‘KEVIN’,’STONE’,’DREWB’);

select nama from infoprib where not id_bin in (‘KEVIN’,’STONE’,’DREWB’);

• Operator LIKE dan NOT LIKE

select nama from infoprib where nama like ‘%on%’;

select nama from infoprib where nama like ‘S%’;

select nama from infoprib where nama not like ‘S%’;

select nama from infoprib where not nama like ‘S%’;

select nama from infoprib where nama like ‘S%a%r%’;

• Operator IS NULL dan IS NOT NULL
select * from infoprib where tgl_lahir = NULL;

select * from infoprib where tgl_lahir is NULL;

select * from infoprib where tgl_lahir is not NULL;

select * from infoprib where not tgl_lahir is NULL;