thanks pak
ampuh

On 4/3/06, madhi <[EMAIL PROTECTED]> wrote:
> select code, sum(price) as Price from table
> group by code
>
> ----- Original Message -----
> From: "PALUARED" <[EMAIL PROTECTED]>
> To: <[email protected]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Monday, April 03, 2006 8:34 AM
> Subject: [Programmer-VB] Tanya Sintak SQL
>
>
> > Dear ALL,
> >
> > tanya sintak sqlnya:
> > Saya punya data seprti berikut :
> >
> > Code         Price
> > B001         2000
> > B001         3000
> > B002         1000
> > B002         2000
> > B003         4000
> >
> > gimana ya supaya jumlah price biar tiap code, seperti di bawah ini
> >
> > Code        Price
> > B0001       5000
> > B0002       3000
> > B0003       4000
> >
> > Thz In Advance
> >
> > --
> > Regards,
> > PALUARED
> >
>
>
>
>
> Wahana Programmer Groups Links
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>


--
Regards,
PALUARED

http://paluared.coconia.net/


Wahana Programmer Groups Links

<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
    http://wahanaprogrammer.net

<*> Untuk menghubungi owner milis ini, kirim email ke:
    [EMAIL PROTECTED]

<*> Konsultasi pemrogramman bisa chat disini:
    Yahoo! Messenger: wahanaprogrammer
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/Programmer-VB/

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


Kirim email ke