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
--
-----------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/
