Tugas PBD 1
Rahardiyan Arya Yudha (10.39010.0025)
06-03-2012
1.
select nim, nama, sex
from master_mhs
where (nim like '00%' or nim like '01%') and nim like
'%39010%' and tgl_lahir like '01-May%' and
sts_marital='M';
2.
select count(*) as "Jumlah Mahasiswa"
from master_mhs
where (nim like '01%' or nim like '02%') and (nim like
'%41010%' or nim like '%39010%');
3.
select y.nim, z.nama
from master_mhs z, histori_mhs y
where y.nim = z.nim and nim like '02%'
group by a.nim
order by a.nim;
4.
select y.nim, z.nama, y.kode_mk
from master_mhs z, histori_mhs y
where y.nim = z.nim and nim like '02%'
group by y.nim, z.kode_mk
0 Responses so far.
Langganan:
Posting Komentar (Atom)
Posting Komentar