BLOGnya NUNUX

Leave a Reply

1. 

   M. Alfan R (07390100041)

   March 6, 2012 at 11:18 am

   select nim,nama,sex
   from master_mhs
   where substr nim (0,1) =’00’
   and substr nim (0,1) =’01’
   and substr nim (2,5) =’39010′
   and tgl_lahir (to_char(‘dd-month’)) in (‘1 Mei’)
   and sts_marital =’M’;

   select distinct count(nim)
   from master_mhs
   where substr nim(2,5)in (‘39010’)
   and substr nim (2,5)= ‘41010’
   group by count(nim);

   select distinct master_mhs.nim,master_mhs.nama
   from master_mhs, histori_mhs
   where master_mhs.nim=histori_mhs.nim
   and substr master_mhs.nim(0,1)in(’02’)
   order by master_mhs.nim

   select distinct master_mhs.nim,master_mhs.nama,jadwal.kelas
   from master_mhs, histori_mhs, jadwal
   where master_mhs.nim=histori_mhs.nim and histori_mhs.kode_mk = jadwal.kode_mk
   and substr master_mhs.nim(0,1)in(’02’)
   order by master_mhs.nim

   Reply

    
2. 

   Teguh B (07390100016)

   March 6, 2012 at 11:19 am

   select nim,nama,sex
   from master_mhs
   where substr nim (0,1) in (’00’,’01’)
   and substr nim (2,5) =’39010′
   and tgl_lahir (to_char(‘dd-month’))=’1 Mei’
   and sts_marital =’M’;

   select distinct count(nim)
   from master_mhs
   where substr nim(2,5)= ‘39010’
   and substr nim (2,5)= ‘41010’
   group by count(nim);

   select distinct a.nim,a.nama
   from master_mhs a, histori_mhs b
   where a.nim=b.nim
   and substr a.nim(0,1)=’02’
   order by a.nim

   select distinct a.nim,a.nama,c.kelas
   from master_mhs a, histori_mhs b, jadwal c
   where a.nim=b.nim and b.kode_mk = c.kode_mk
   and substr a.nim(0,1)=’02’
   order by a.nim

   Reply

    
3. 

   Ign. Dimas (08390100037)

   March 6, 2012 at 11:20 am

   select nim,nama,sex
   from master_mhs
   where substr nim (0,1) =’00’
   and substr nim (0,1) =’01’
   and substr nim (2,5) =’39010′
   and tgl_lahir (to_char(‘dd-month’))=’1 Mei’
   and sts_marital =’M’;

   select distinct count(nim)
   from master_mhs
   where substr nim(2,5) in(‘39010′,’41010′)
   group by count(nim);

   select distinct master_mhs.nim,master_mhs.nama
   from master_mhs, histori_mhs
   where master_mhs.nim=histori_mhs.nim
   and substr master_mhs.nim(0,1)=’02’
   order by master_mhs.nim

   select distinct master_mhs.nim,master_mhs.nama,jadwal.kelas
   from master_mhs, histori_mhs, jadwal
   where master_mhs.nim=histori_mhs.nim and histori_mhs.kode_mk = jadwal.kode_mk
   and substr master_mhs.nim(0,1)=’02’
   order by master_mhs.nim

   Reply