Latihan DML

Menampilkan lebih dari dua table

select *

from table_mahasiswsa, tabel_jurursan, tabel_matakuliah

Order by

select *

from table_mahasiswsa

order by Nama_depan DESC

Group by

select Nama_depan,count(Nama_depan)

from table_mahasiswsa

group by Nama_depan

Having

select Nama_depan,count(Nama_depan)

from table_mahasiswsa

group by Nama_depan

having count(Nama_depan)>0

Operator AND

select *

from table_mahasiswsa

where nama_depan='aulian'AND tempat_lahir='klaten'

Operator OR

select *

from table_mahasiswsa

where nama_depan='aulian' OR tempat_lahir='klaten'

Operator IN

select *

from table_mahasiswsa

where nama_depan

in('aulian','basira')

Operator BETWEEN….AND

select *

from table_mahasiswsa

where nama_depan

between'aulian'and'basira'

Fungsi agregat COUNT

select count(Nama_depan) as jumlahmahasiswa

from table_mahasiswsa

Fungsi agregat SUM

select sum(sks) as totalsks

from tabel_matakuliah

Fungsi agregat AVG

select avg(sks) as ratasks

from tabel_matakuliah

Fungsi agregat MIN

select min(sks) as jumlahminumum

from tabel_matakuliah

Fungsi agregat MAX

select max(sks) as jumlahmaksimum

from tabel_matakuliah