Pengantar Bahasa Query:Tugas 2: Difference between revisions
No edit summary |
|||
| Line 36: | Line 36: | ||
==Perintah Select== | ==Perintah Select== | ||
*Menampilkan Semua field | |||
select * from karyawan | |||
'''Output''' | |||
+----------------+--------------+---------+--------+ | |||
| nama | pekerjaan | gaji | mkerja | | |||
+----------------+--------------+---------+--------+ | |||
| SUNARDI | STAF AHLI | 1500000 | 3 | | |||
| AHMAD ZAENUDIN | DIREKTUR | 5000000 | 8 | | |||
| JOKO MARTADI | ADMINISTRASI | 800000 | 2 | | |||
| SUKOTJO | KEAMANAN | 500000 | 3 | | |||
| ANDI SANYOTO | PEMBUKUAN | 1000000 | 4 | | |||
| SANTOSO | ADMINISTRASI | 1200000 | 6 | | |||
| MARIYANTI | STAF AHLI | 2000000 | 1 | | |||
| RATMANTO | KEAMANAN | 750000 | 4 | | |||
| MAHENDRA | SALESMAN | 1000000 | 6 | | |||
| PARMADI BUDI | ADMINISTRASI | 2000000 | 7 | | |||
| INDAH MULYONO | SEKRETARIS | 3000000 | 5 | | |||
| ARIS HARYANTO | STAF AHLI | 1800000 | 3 | | |||
| SARAJAYA | SALESMAN | 1200000 | 1 | | |||
| GUNARSO HALIM | STAF AHLI | 1500000 | 1 | | |||
+----------------+--------------+---------+--------+ | |||
*Tampilkan yang namanya di awali dengan huruf depan S | *Tampilkan yang namanya di awali dengan huruf depan S | ||
select * from karyawan where nama like 'S%'; | select * from karyawan where nama like 'S%'; | ||