Posted by : Rizky Tuesday 6 March 2012

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

{ 1 comments... read them below or add one }

  1. Play Coin Casino Online with Bitcoins
    Play casino 카지노 with the best Bitcoin casino site ⚡️ Enjoy great bonuses and worrione get free coins with no 인카지노 deposit required. ⚡️ Try the free

    ReplyDelete

- Copyright © RIZKY BLOG,..おかしい..甘いエービス.. - Blogger Templates - Powered by Blogger - Designed by Johanes Djogan -