Database - Mengenal Dasar Query Tabel

• Menampilkan Semua Kolom Semua Baris

select * from infoprib;
select id_bin,nama,tgl_lahir,sex
from infoprib;

• Menampilkan kolom tertentu

select nama, tgl_lahir
from infoprib;

atau
select id_bin, nama, sex from infoprib;
atau
select id_bin, tgl_lahir from infoprib;


• Memperoleh Data yang unik

select sex from infoprib;

atau
select distinct sex from infoprib;
atau
select distinct kota from pegawai;

• Memilih baris Tertentu

select nama from infoprib where sex=‘W’;

select * from infoprib where id_bin=‘DREWB’;

select nama from infoprib where tgl_lahir=NULL;

select nama from infoprib where tgl_lahir is NULL;

• Mengenal Operator Relasional

select nama, tgl_lahir from infoprib where tgl_lahir > ‘19561231’;

select nama_peg, gaji from pegawai where gaji > 2000000;

• Mengenal Operator Boolean
– Operator OR

select * from infoprib where sex=‘P’ or id_bin=‘STONE’;
NULL or benar -> benar
NULL or salah -> NULL

select nama, tgl_lahir from infoprib where sex=‘W’ or tgl_lahir=NULL;

select nama, tgl_lahir from infoprib where sex=‘W’ or tgl_lahir is NULL;

– Operator AND
select nama, tgl_lahir from infoprib where sex=‘P’ and tgl_lahir < ‘1950-01-01’;
? and salah -> salah
? and benar ->  ?
benar and benar -> benar
NULL and benar -> NULL

– Operator NOT
select nama from infoprib where not sex=‘P’;

select nama from infoprib where not sex=‘W’;

select nama, tgl_lahir from infoprib where not (tgl_lahir > ‘19491231’ and tgl_lahir < ‘19600101’);