Kalo tidak salah, SELECT MatKul, Max(nilai) as NMax, Min(nilai) as NMin, Avg(nilai) as Average from MHS GROUP BY MatKul
----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, October 12, 2006 3:58 PM Subject: [Programmer-VB] Tanya Query Lagi > > 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 > > Yahoo! Groups Links > > > > 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/
