create database "201553041c"
use "201553041c"
create table
Barang
(kdbrg varchar(10) primary key,
nmbrg
varchar(50),
jnsbrg
varchar(20),
harga
int,
jumlah
int
)
select *
from Barang;
insert into
Barang
values ('001','clear','shampo',16000,150)
insert into
Barang
values ('002','djarum','rokok',18000,500)
insert into
Barang
values ('003','lifebouy','sabun',7000,250)
insert into
Barang
values ('004','Biscuit roma','snack',12000,400)
insert into
Barang
values ('005','indomilk','susu bayi',25000,300)
select *
from Barang where
nmbrg = 'clear'
select *
from Barang
select *
from Barang where
jnsbrg = 'shampo'
select *
from Barang where
harga = 1800
select *
from Barang where
jumlah = 250
select *
from Barang where
jnsbrg = 'susu bayi'
select *
from barang where
nmbrg = 'clear' and nmbrg = 'lifebouy'
select *
from barang where
nmbrg = 'djarum'
or nmbrg = 'indomilk'
select *
from barang where
harga = 12000 and
harga = 25000
select *
from barang where
jumlah = 400 or
jumlah = 500
select *
from barang where
nmbrg = 'Biscuit roma'
or jumlah = 250
Tugas :
Tampilkan
yang namanya clear
select * from Barang where nmbrg = 'clear'
1. Tampilkan
yang jenisnya shampoo
select * from Barang where jnsbrg = 'shampo'
1. Tampilkan
yang harganya 18000
select * from Barang where harga = 1800
1. Tampilkan
yang jumlahnya 250
select * from Barang where jumlah = 250
1. Tampilkan
yang jenisnya susu
select * from Barang where jnsbrg = 'susu bayi'
1. Tampilkan
yang namanya clear & lifebuoy
select * from barang where nmbrg = 'clear' and nmbrg = 'lifebouy'
1. Tampilkan
yang namaya djarum or indomilk
select * from barang where nmbrg = 'djarum' or nmbrg = 'indomilk'
1. Tampilkan
yang harganya 12000 dan 25000
select * from barang where harga = 12000 and harga = 25000
1. Tampilkan
yang jumlahnya 400 atau 500
select * from barang where jumlah = 400 or jumlah = 500
1. Tampilkan
yang namanya biscuit roma atau jumlahnya 250
select * from barang where nmbrg = 'Biscuit roma' or
jumlah = 250
No comments:
Post a Comment