Table gaji karyawan
No | Nama | Jabatan | Golongan | Gaji |
1 | Amalia | Office | 2 A | Rp 1500000; |
2 | Dimas mandala | Programmer | 1 B | Rp 2500000; |
3 | Egy | Office | 2 B | Rp 1500000; |
4 | Galih | Sekretaris | 1 A | Rp 3500000; |
5 | Harri | Office | 2 A | Rp 1500000; |
6 | Lana Muhamad | Office | 2 B | Rp 1500000; |
7 | Nerri Susanti | Programmer | 1 B | Rp 2500000; |
8 | Putri Dwi Sari | Sekretaris | 1 A | Rp 3500000; |
9 | Rizky Arya | Office | 2 B | Rp 1500000; |
10 | Susan Susanti | Office | 2 A | Rp 1500000; |
v Create
(No char (2) not null,
Nama char (20) not null,
Jabatan char (10),
Golongan char (3),
Gaji char (12),
Foregn key (Golongan));
v Insert
Insert into TABEL GAJI KARYAWAN values (‘1’,’Amalia’,’Office’,’2 A’,’Rp 1500000’);
Insert into TABEL GAJI KARYAWAN values (‘2’,’Dimas Mandala’,’Programmer’,’1 B’,’Rp 2500000’);
Insert into TABEL GAJI KARYAWAN values (‘3’,’Egy’,’Office’,’2 B’,’Rp 1500000’);
Insert into TABEL GAJI KARYAWAN values (‘4’,’Galih’,’Sekretaris’,’1 A’,’Rp 3500000’);
Insert into TABEL GAJI KARYAWAN values (‘5’,’Harri’,’Office’,’2 A’,’Rp 1500000’);
Insert into TABEL GAJI KARYAWAN values (‘6’,’Lana Muhamad’,’Office’,’2 B’,’Rp 1500000’);
Insert into TABEL GAJI KARYAWAN values (‘7’,’Nerri Susanti’,’Programmer’,’1 B’,’Rp 2500000’);
Insert into TABEL GAJI KARYAWAN values (‘8’,’Putri Dwi Sari’,’Sekretaris’,’1 A’,’Rp 3500000’);
Insert into TABEL GAJI KARYAWAN values (‘9’,’Rizky Arya’,’Office’,’2 B’,’Rp 1500000’);
Insert into TABEL GAJI KARYAWAN values (‘10’,’Susan Susanti’,’Office’,’2 A’,’Rp 1500000’);
v Select
Select * TABEL GAJI KARYAWAN
Tidak ada komentar:
Posting Komentar