dear all, mo nanya soal query

ada table t1, dg rows sbb :

nama  jumlah    type
AA    100000     sales
AA    10000      pajak
BB    200000     sales
BB    20000      pajak

dst ...

kalo pengin result querynys spt ini

nama     sales   pajak
AA      100000   10000
BB      200000   20000
dst

gimana querynya ya,

regards


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com


--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------

Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com




SPONSORED LINKS
Membership database software Database mortgage software Pda database software
Database management software Oracle database administration Oracle database management


YAHOO! GROUPS LINKS




Kirim email ke