Selasa, 06 Maret 2012

Tugas PBD . .

1. Select NIM , NAMA , SEX
    From MASTER_MHS
    Where NIM like '00%' or NIM like '01%' and substr (NIM,3,5) = '39010'
    and STS_MARITAI = 'M' and TGL_LAHIR like '01-MAY%';

2.Select COUNT * From MASTER_MHS
  Where substr (NIM,3,5) = '39010' and substr (NIM,3,5) = '41010' and NIM like '%01' or NIM like '%02';
3. select a.NIM, b.NAMA
from HISTORI_MHS a, MASTER_MHS b
where a.NIM = b.NIM and a.NIM like '02%'
order by a.NIM;

4. select a.NIM, b.NAMA, c.KODE_MK
from HISTORI_MHS a, MASTER_MHS b, JADWALl c
where a.NIM = b.NIM and c.KODE_MK = a.KODE_MK and a.NIM like '02%' 
order by a.NIM;
Baca SelengkapnyaTugas PBD . .