Tugas KU Perintah Select

1 use dbretail

select ID,keterangan
from tbsatuan


2 use dbretail

select ID,keterangan
from tbsatuan
where keterangan='bungkus'


3 use dbretail

select ID,keterangan
from tbsatuan
where keterangan like 'b%'


4 use dbretail

select ID,keterangan
from tbsatuan
where keterangan like '%g'


5 use dbretail

select ID,keterangan
from tbsatuan
where keterangan='bungkus'or id='2'



6 use dbretail

select keterangan
from tbsatuan

7 use dbretail

select id,namabarang, idsatuan,hbeli,hjual,jumlah,status
from tbbarang

8 use dbretail

select id,namabarang, idsatuan,hbeli,hjual,jumlah,status
from tbbarang
where hbeli < 50000


9 use dbretail

select id,namabarang, idsatuan,hbeli,hjual,jumlah,status
from tbbarang
where jumlah > 5

10 use dbretail

select namabarang,jumlah,status
from tbbarang
where status='A'