sintax sql

sintax sql

--- jawaban no 1 ----
insert into tbl_barang
values ('1001','hardisk','500000','2')


Create database aghy
use aghy gp

create table tbl_barang
(kd_barang varchar (10),
nm_barang varchar (35),
harga dec)

insert into tbl_barang
values ('A01','Buku','1000')
insert into tbl_barang
values ('A02','Pensil','500')
insert into tbl_barang
values ('K01','Hardisk','400000')
insert into tbl_barang
values ('K02','Mouse','50000')

select * from tbl_barang

--- jawaban no.2 ---
select * from tbl_barang
where kd_barang like 'K%'

--- Jawaban no.3 ---
select * from tbl_barang
where nm_barang = 'pensil'



--- jawaban no. 4 ---
update tbl_barang
set nm_barang = 'Keyboard'
where kd_barang = 'K01'

--- jawaban no. 5 ---
select kd_barang,nm_barang,harga,
case left (kd_barang,1)
when 'A' then 'ATK'
When 'K' then 'Komputer'
end kategori
from tbl_barang

--- jawaban no. 6 ---
delete tbl_barang
where kd_barang = 'A02'