Field
|
Type
|
Size
|
Keterangan
|
Kdsup
|
Varchar
|
10
|
Primary Key
|
Nmsup
|
Varchar
|
50
| |
Tgllhr
|
Date
|
8
| |
Alamatkantor
|
Varchar
|
50
| |
Telpkantor
|
Varchar
|
15
| |
Jekel
|
Varchar
|
15
| |
Email
|
Varchar
|
20
|
Coding:
use "201553022"
create table Supplier(
Kdsup Varchar(10) Primary Key,
Nmsup Varchar(50),
Tgllhr date,
Alamatkantor Varchar(50),
Telpkantor Varchar(15),
Jekel Varchar(15),
Email Varchar(20)
)
Lalu isikan sebanyak 3 data,
Isi Data
Kdsuop
|
Nmsup
|
Tgllhr
|
Alamatkantor
|
Telpkantor
|
Jekel
|
Email
|
Sup001
|
Firman Ilahudin
|
12/04/1980
|
Jl. Gondang Manis
|
0291-5546738
|
Pria
| |
Sup002
|
Joko Waluyo
|
07/03/1979
|
Jl. Bumi Wonosari
|
024-889772
|
Pria
| |
Sup003
|
Ilham Wahid
|
09/08/1982
|
Jl. Dersalam
|
0291-889324
|
Pria
|
select*from supplier
select*from Supplier
insert into Supplier
values ('Sup001','Firman Ilahudin','12/04/1980','Jl. Gondang Manis','0291-546738','Pria','Firman001@gmail.com')
insert into Supplier
values ('Sup002','Joko Waluyo','07/03/1979','Jl. Bumi Wonosari','024-889772','Pria','Jwal@gmail.com')
insert into Supplier
values ('Sup003','Ilham Wahid','09/08/1982','Jl. Dersalam','024-71256','Pria','Wahid@gmail.com')
insert into Supplier
values ('Sup004','Shinta Ulfiana','05/25/1982','Jl.Demak','024-71356','Wanita','shinta@gmail.com')
insert into Supplier
values ('Sup005','Yunita Lestari','03/06/1997','Jl. Rendeng','024-888772','Wanita','YunatiL@gmail.com')
insert into Supplier
values ('Sup006','Rita Suryana','04/24/1997','Jl. Pati Rembang','028-888771','Wanita','PeloRita@gmail.com')
insert into Supplier
values ('Sup007','Yulimar','10/17/1997','Jl. Pwd','025-888771','Wanita','Yulimarmut@gmail.com')
insert into Supplier
values ('Sup008','Fiki Faizal','01/19/2004','Jl. Demak Jepara','027-878771','Pria','FikiFaizal@gmail.com')
insert into Supplier
values ('Sup009','Mafula','10/24/1990','Jl. Demak','024-71276','Wanita','Mafula@gmail.com')
insert into Supplier
values ('Sup010','Umar','01/30/1995','Jl. Kudus','024-82276','Pria','Umar@gmail.com')
select*from Supplier where Alamatkantor='Jl. Dersalam'
select*from Supplier where Alamatkantor='Jl. Gondang Manis'
select*from Supplier where Alamatkantor='Semarang'
select*from Supplier where Alamatkantor='Jl. Rendeng'
select*from Supplier where Alamatkantor='Jl.Demak'
select*from Supplier where Alamatkantor='Jl. Kudus'
select*from Supplier where Alamatkantor='Jl. Demak Jepara'
select*from Supplier where Alamatkantor='Jl. Pwd'
select*from Supplier where Alamatkantor='Jl. Pati Rembang'
select*from Supplier where Alamatkantor='Jl. Bumi Wonosari'
insert into Supplier
values ('Sup001','Firman Ilahudin','12/04/1980','Jl. Gondang Manis','0291-546738','Pria','Firman001@gmail.com')
insert into Supplier
values ('Sup002','Joko Waluyo','07/03/1979','Jl. Bumi Wonosari','024-889772','Pria','Jwal@gmail.com')
insert into Supplier
values ('Sup003','Ilham Wahid','09/08/1982','Jl. Dersalam','024-71256','Pria','Wahid@gmail.com')
insert into Supplier
values ('Sup004','Shinta Ulfiana','05/25/1982','Jl.Demak','024-71356','Wanita','shinta@gmail.com')
insert into Supplier
values ('Sup005','Yunita Lestari','03/06/1997','Jl. Rendeng','024-888772','Wanita','YunatiL@gmail.com')
insert into Supplier
values ('Sup006','Rita Suryana','04/24/1997','Jl. Pati Rembang','028-888771','Wanita','PeloRita@gmail.com')
insert into Supplier
values ('Sup007','Yulimar','10/17/1997','Jl. Pwd','025-888771','Wanita','Yulimarmut@gmail.com')
insert into Supplier
values ('Sup008','Fiki Faizal','01/19/2004','Jl. Demak Jepara','027-878771','Pria','FikiFaizal@gmail.com')
insert into Supplier
values ('Sup009','Mafula','10/24/1990','Jl. Demak','024-71276','Wanita','Mafula@gmail.com')
insert into Supplier
values ('Sup010','Umar','01/30/1995','Jl. Kudus','024-82276','Pria','Umar@gmail.com')
select*from Supplier where Alamatkantor='Jl. Dersalam'
select*from Supplier where Alamatkantor='Jl. Gondang Manis'
select*from Supplier where Alamatkantor='Semarang'
select*from Supplier where Alamatkantor='Jl. Rendeng'
select*from Supplier where Alamatkantor='Jl.Demak'
select*from Supplier where Alamatkantor='Jl. Kudus'
select*from Supplier where Alamatkantor='Jl. Demak Jepara'
select*from Supplier where Alamatkantor='Jl. Pwd'
select*from Supplier where Alamatkantor='Jl. Pati Rembang'
select*from Supplier where Alamatkantor='Jl. Bumi Wonosari'
select*from Supplier
Dari perintah diatas ada beberapa soal dibawah sebagai berikut :
a. Tampilkan Data Supplier yang kantornya daerah Dersalam
b. Tampilkan Data Email Supplier yang rumahnya daerah gondangmanis
select*from Supplier where Alamatkantor='Jl. GondangManis'
c. Tampilkan Data Supplier yang rumahnya daerah Semarang
select*from Supplier whereAlamatkantor='Semarang'
Tidak ada data yang ditampilkan, karena tidak ada Supplier yang alamatnya di Semarang.
d. Tampilkan Data Supplier yang memiliki jenis kelamin Pria
select*from Supplier where Jekel='Pria'
e. Tampilkan Data Supplier yang nama suppliernya Firman Ilahudin dan jenis kelaminnya Pria
select*from Supplier where Nmsup='Firman Ilahudin'and jekel='Pria'
g. Tampilkan Data Supplier yang nama suppliernya Sinta Ulfiana dan Kode Suppliernya 004
select*from Supplier where Nmsup='Sinta Ulfiana'and kdsup='004'
Hasilnya
tidak ada data yang tampil, karena memang Supplier yang namanya
Sumiyati tidak memiliki kode Supplier 002 melainkan 004.
select*from Supplier where Nmsup='Sinta Ulfiana'
i. Tampilkan Data Supplier yang kode suppliernya 001 atau 010
select*from Supplier where kdsup='001'or kdsup='010'
j. Tampilkan Data Supplier yang nama suppliernya Ade Raya dan jenis kelaminnya Pria
select*from Supplier where Nmsup='Fiki Faizal'
Tidak ada komentar:
Posting Komentar