Dah bisa mas, thanks ya.. btw, besok tanya-tanya lagi ya... GBU
On 8/8/06, Ferry Setiawan <[EMAIL PROTECTED]> wrote: > > select * from > ( select p.prod_id, p.prod_name, p.prod_list_price list,count(s.prod_id) > as banyak > from product p, sales2 s > where p.prod_id=s.prod_id > having count(s.prod_id) >= 3 <-- tambahkan ini > > group by p.prod_id, p.prod_name, p.prod_list_price > order by banyak desc > ) > where rownum <=10; > > > Teman-teman saya minta tolong dikoreksi serta ditambahkan kueri yang > saya > > buat berikut ini: > > > > select * from > > ( select p.prod_id, p.prod_name, p.prod_list_price > > list,count(s.prod_id) as > > banyak > > from product p, sales2 s > > where p.prod_id=s.prod_id > > group by p.prod_id, p.prod_name, p.prod_list_price > > order by banyak desc > > ) > > where rownum <=10; > > > > > > Hasil running dari kueri di atas adalah sebagai berikut. > > > > PROD_ID PROD_NAME LIST > > BANYAK > > ---------- > > -------------------------------------------------- > > ---------- ---------- > > 15 Envoy 256MB - 40GB > > 999.99 > > 4 > > 18 Envoy Ambassador > > 1299.99 > > 4 > > 13 5MP Telephoto Digital Camera 899.99 > > 3 > > 28 Unix/Windows 1-user pack > > 199.99 > > 3 > > 25 SIMM- 8MB PCMCIAII card 112.99 > > 3 > > 14 17" LCD w/built-in HDTV Tuner > > 999.99 > > 3 > > 24 PCMCIA modem/fax 28800 baud 45.99 > > 2 > > 27 Multimedia speakers- 3" cones > > 44.99 > > 2 > > 16 Y Box > > 299.99 1 > > 17 Mini DV Camcorder with 3.5" Swivel LCD 1099.99 > > 1 > > > > 10 rows selected. > > > > Saya bermaksud hanya menampilkan barang yang jumlahnya >= 3. > > Untuk itu tolong teman-teman mengoreksi dan menambahkan kueri > > yang saya buat > > di atas. > > > > Sebelumnya saya ucapkan terima kasih > > > > Best Regards > > > > D'Sudi > > > [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> 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/
