12 Mar 2007

PBD 1

TUGAS PBD 1
1.
select nim, nama, sex from master_mhs
where substr(2,1) = ('00','01') and tgl_lahir like '01-05' and sts_marital = upper('M');

2.
select count (nim) from master_mhs
where nim = ('%41010','39010') and nim = ('%01','%02');

3.
select a.nim, a.nama from a.master_mhs b.histori_mhs
where a.nim = b.nim and nim like ('02%')
order by a.nim

Tidak ada komentar:

Posting Komentar