SUM(DECODE(TIPE,'pajak',JUMLAH,0)) PAJAK
FROM TABLE_A
GROUP BY NAMA
Salam,
Indra Armansyah
----- Original Message -----
From: "abang sunda" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, May 22, 2006 3:12 PM
Subject: [indo-oracle] [ask] tanya query SQL
> 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
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.375 / Virus Database: 268.6.1/344 - Release Date: 5/19/2006
>
>
--
-----------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
- Visit your group "indo-oracle" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
