sebaiknya Anda belajar dulu SQL Script
terutama yang bagian aggregat.
Select MataKuliah,Max(Nilai),Min(Nilai),Avg(Nilai)
From Tabel
Group by MataKuliah
Semoga membantu
Dhaman
[EMAIL PROTECTED] wrote:
>
> Assalamualikum...
>
> minta bantuannya neh
>
> misal punya tabel
>
> NIM MATA KULIAH NILAI
>
> 001 FISIKA 60
> 002 FISIKA 75
> 003 FISIKA 80
> 001 MATEMATIKA 45
> 003 MATEMATIKA 60
>
> MENJADI
>
> MATA KULIAH NILAI MAX NILAI MIN AVERAGE
>
> FISIKA 80 60 71.6
> MATEMATIKA 60 45 52.5
>
> Salam
>
> Ali Akbar
>
>
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/Programmer-VB/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
