Hai milisers, Sori kalau pertanyaannya agak khusus SQL. Lagi belajar tutorial singkat SQL: "Sams Teach Yourself SQL in 10 Minutes, Third Edition"
mysql> select prod_price from products; +------------+ | prod_price | +------------+ | 5.99 | | 8.99 | | 11.99 | | 3.49 | | 3.49 | | 3.49 | | 4.99 | | 9.49 | | 9.49 | +------------+ 9 rows in set (0.00 sec) mysql> select distinct prod_price from products; +------------+ | prod_price | +------------+ | 5.99 | | 8.99 | | 11.99 | | 3.49 | | 4.99 | | 9.49 | +------------+ 6 rows in set (0.06 sec) mysql> select avg(prod_price) from products; +-----------------+ | avg(prod_price) | +-----------------+ | 6.823333 | +-----------------+ 1 row in set (0.00 sec) Nah, sekarang apa yg terjadi bila fungsi AVG() dikombinasikan dengan DISTINCT ? mysql> select avg(distinct prod_price) from products; ERROR 1064: You have an error in your SQL syntax near 'distinct prod_price) from products' at line 1 Padahal perintah di atas saya dapatkan dari tutorial SQL. Ini MySQL bawaannya PHPTriad. C:\>mysql -V C:\APACHE\MYSQL\BIN\MYSQL.EXE Ver 11.12 Distrib 3.23.32, for Win95/Win98 (i32) Oya, saya juga sudah coba perintahnya di MySQL bawaannya package RedHat 7.3. Hasilnya juga error. Any help, please ? Mungkin perlu upgrade ke versi lebih baru/ TIA ~yudi -- Unsubscribe: kirim email kosong ke [EMAIL PROTECTED] Arsip dan info di http://linux.or.id/milis.php FAQ milis http://linux.or.id/faq.php
