Tugas T7H7 PSQLB

1. Membuat Table Retur Jual


3. Update Table


6. Tambah 5 Data


7. Update 3 data retur


8. Delete 1 retur


9. Menambah jenis paket


10. isi jenis paket

Komentar

Posting Komentar

Postingan populer dari blog ini

Praktek SQL 2

Gambar
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)) select*from supplier insert into supplier values('sup001','Firman Ilahudin','1980/04/12','Jl. Gondang Manis','0291-5546738','Pria','Firman001@gmail.com') insert into supplier values('sup002','Joko Waluyo','1979/03/07','Jl.Bumi Winosari','024-889772','Pria','Jwal@gmail.com') insert into supplier values('sup003','Ilham Wahid','1982/08/19','Jl. Dersalam','0291-889324','Pria','Wahid@gmail.com') insert into supplier values('sup004','Farid Yuliyanto','1997/07/18','Jl. Krandon','0291-657457','Pria','Farid@gmail.com') insert into supplier values('sup0
Baca selengkapnya

Tugas PSQL (T6H6) Kelas B

Gambar
Tugas Kelompok disini kami membuat form berupa inputan table barang, table supplier, dan table pembelian. berikut tampilannya: 1.Tampilan Menu Login 2. Tampilan Menu Utama 3. Tampilan Menu Barang 4. Tampilan Menu Pembelian 5. Tampilan Menu Supplier 6. Tampilan Menu Ganti Password
Baca selengkapnya

Praktek SQL

Gambar
create database "201553031" use "201553031" 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', 'Indomie', 'mie instan', 2000, 50) insert into barang values ('002', 'Sunsilk', 'Shampoo', 14000, 100) insert into barang values ('003', 'Pepsodent', 'pasta gigi', 7000, 75) insert into barang values ('004', 'LA Light', 'rokok', 18000, 200) insert into barang values ('005', 'SGM 3', 'Susu Bayi', 75000, 150) select * from barang 1. Tampilkan yang nama barangnya indomie select * from barang where nmbrg='indomie' 2. Tampilkan yang jenisnya shampoo select * from barang where jnsbrg='shampoo' 3. Tampilkan yang harganya 18000 select * from bar
Baca selengkapnya