"Tanya Jawab Linux" <[EMAIL PROTECTED]> wrote on 04/06/2004 17:37:06:
> > 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 Mas Yudi, Coba upgrade MySQL nya ke versi 5.0. Kalau query diatas masih gagal, mungkin bisa dicoba query berikut: mysql>select avg(a.price) from mysql>(select distinct(prod_price) as price from products) as a; Semoga berhasil. Best regards, Jhon Ramawi Putra -- 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
