TUGAS PBD


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_marital=’M’
And tgl_lahir like ’01-MAY%’;

2.       Select count (*)
From master_mhs
Where substr(nim,3,5)=’39010’
Or substr(nim,3,5)=’41010’
And nim like’01%’or nim like’02%’;

3.       Select x.nim,y.nama
From histori_mhs x, master_mhs y
Where x.nim=y.nim
And x.nimlike’02%’
Order by x. nim;

4.       Select x.nim,y.nama,z.kode_mk
From histori_mhs x, master_mhs y,jadwal z
Where x.nim=y.nim
And z.kode_mk=x.kode_mk
And x.nimlike’02%’
Order by x.nim;

nim :10390100056

Categories: Share

Leave a Reply

Total Pageviews

You can replace this text by going to "Layout" and then "Page Elements" section. Edit " About "

Selasa, 06 Maret 2012

TUGAS PBD

Diposting oleh Zeniwahyu di 7:34:00 PM

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_marital=’M’
And tgl_lahir like ’01-MAY%’;

2.       Select count (*)
From master_mhs
Where substr(nim,3,5)=’39010’
Or substr(nim,3,5)=’41010’
And nim like’01%’or nim like’02%’;

3.       Select x.nim,y.nama
From histori_mhs x, master_mhs y
Where x.nim=y.nim
And x.nimlike’02%’
Order by x. nim;

4.       Select x.nim,y.nama,z.kode_mk
From histori_mhs x, master_mhs y,jadwal z
Where x.nim=y.nim
And z.kode_mk=x.kode_mk
And x.nimlike’02%’
Order by x.nim;

nim :10390100056

0 komentar on "TUGAS PBD"

Posting Komentar