RE: [Programmer-VB] Tanya Select Distinct

Wed, 14 Jun 2006 21:12:27 -0700

Dear De Ce,

 

Kalau begitu diconvert aja mas data jamnya, baru di sum.

Select Kode, Rinician, User, Tgl, sum(cast(Jam as int)) as hour FROM DETAIL group by Kode, Rinician, User, Tgl

Atau

Select Kode, Rinician, User, Tgl, sum(A.hour) FROM

FROM

(Select Kode, Rinician, User, Tgl, cast(Jam as int) as hour FROM DETAIL) A

GROUP BY

A.Kode, A.Rinician, A.User, A.Tgl

 

Mudah-mudahan bisa membantu.

 

Regards,

 

 

From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of De ce
Sent: Thursday, June 15, 2006 9:18 AM
To: [email protected]
Subject: Re: [Programmer-VB] Tanya Select Distinct

 

Mas-mas sekalian,

Saya sudah coba dengan:

Select Kode, Rinician, User, Tgl, sum(Jam) as hour FROM DETAIL group by Kode, Rinician, User, Tgl

Tapi keluar error 3464 - Data type mismatch in criteria _expression_

Untuk informasi saja field JAM itu bukan number tapi text apa harus saya rubah ke number ya? (maaf ini tabel warisan)

Trims.

tahar dn <[EMAIL PROTECTED]> wrote:

Kayaknya nya begini sintak sqlnya  :

 

"select code,act,user,date,sum(hour) hour from ..... group by code,act,user,date

mudah-mudahan bisa



De ce <[EMAIL PROTECTED]> wrote:

Rekan mau tanya nih,

Code     Act                          User       Date                Hour
0001     Administrasi              Budi       14/06/2006         1
0002     Marketing                 Budi       14/06/2006          4
0003     Meeting                    Budi       14/06/2006          1
0001     Administrasi             Budi        14/06/2006         1

Data di atas kode 0001 terdapat 2 transaksi dan yang ingin saya tanyakan bagaimana command untuk bisa search sekalian filter dengan tampilan sbb:

Code   Act                    User         Date                 Hour
0001   Administrasi       Budi          14/06/2006          2
0002   Marketing           Budi          14/06/2006          4
0003   Meeting             Budi           14/06/2006         1

Kalau saya menggunakan query select distinct code ... maka penjumlahan jamnya tidak ada. Mohon bantuannya.
Terima kasih

ME

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

 

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

 

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

__._,_.___

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




SPONSORED LINKS
Programmer Indonesia Basic programming language
Computer programming languages Programming languages Java programming language

YAHOO! GROUPS LINKS



__,_._,___

Kirim email ke