RIZKY BLOG,..おかしい..甘いエービス..

Jawaban Tugas PBD I


1. Select NIM, NAMA, SEX from MASTER_MHS Where NIM like '2000%' and like '2001%' and  SYSDATE (‘Mei 1 ’,’Month dd') and STS_Marital = "M";

2. Select Count(*) from Master_MHS Where NIM = "41010" Like ('2001%') and NIM = "39010" Like ('2002%);

3. Select NIM.h, NAMA.m from h.HISTORY_MHS, m.MASTER_MHS Where NAMA.m and NIM.h Like ('%02') order by NIM;

4.  Select KODE_MK.j, NIM.h, NAMA.m from j.JADWAL, h.HISTORY_MHS, m.MASTER_MHS;


Nama: Rizky Yanwinarto
Nim: 10390100023