TABEL GAJI KARYAWAN
No | Nama | Jabatan | Golongan | Gaji |
1 | Amalia Safitri | Office | 2 A | Rp 1500000; |
2 | Dimas Susanto | Programmer | 1 B | Rp 2500000; |
3 | Edo Raharjo | Office | 2 B | Rp 1500000; |
4 | Galih Firmantoro | Sekretaris | 1 A | Rp 3500000; |
5 | Harri Mulyana | 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 Amaludin | Office | 2 B | Rp 1500000; |
10 | Susan Susanti | Office | 2 A | Rp 1500000; |
Ø Create
(No char (2) not null,
Nama char (20) not null,
Jabatan char (10),
Golongan char (3),
Gaji char (12),
Foregn key (Golongan));
Ø Insert
Insert into TABEL GAJI KARYAWAN values (‘1’,’Amalia Safitri’,’Office’,’2 A’,’Rp 1500000’);
Insert into TABEL GAJI KARYAWAN values (‘2’,’Dimas Susanto’,’Programmer’,’1 B’,’Rp 2500000’);
Insert into TABEL GAJI KARYAWAN values (‘3’,’Edo Raharjo’,’Office’,’2 B’,’Rp 1500000’);
Insert into TABEL GAJI KARYAWAN values (‘4’,’Galih Firmantoro’,’Sekretaris’,’1 A’,’Rp 3500000’);
Insert into TABEL GAJI KARYAWAN values (‘5’,’Harri Mulyana’,’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 Amaludin’,’Office’,’2 B’,’Rp 1500000’);
Insert into TABEL GAJI KARYAWAN values (‘10’,’Susan Susanti’,’Office’,’2 A’,’Rp 1500000’);
Ø Select
Select * TABEL GAJI KARYAWAN
Tidak ada komentar:
Posting Komentar