Wah thanks ya ... it's done ... :-)
Regards,
~subchan
________________________________
From: Programmer-VB@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Mario Indra Jaya
Sent: Monday, May 28, 2007 6:33 PM
To: Programmer-VB@yahoogroups.com
Subject: RE: [Programmer-VB] Tanya perintah SQL
Numpang jalur umum ya.
Coba ini.
NB : Jika di Access, gunakan query didalam pake view.
Kalo di SQL Server, querynya :
Select tbl2.col1, tbl2.col2, tbl1.col3
from a2 tbl1 inner join
(
select col1, col2=max(col2)
from a2
group by col1
) tbl2
on tbl1.col1=tbl2.col1 and tbl1.col2=tbl2.col2
order by tbl2.col1, tbl1.col3, tbl2.col2 desc
Best regards,
________________________________
From: Agustono, Subchan
[mailto:[EMAIL PROTECTED]
Sent: 28 Mei 2007 16:55
To: Programmer-VB@yahoogroups.com
Subject: RE: [Programmer-VB] Tanya perintah SQL
Thx ya Neng Lilis,
Kalo pake ini, hasil query sama kayak source table. Tapi gak
pa-pa deh, sebenarnya pake SAS yang mempunyai fasilitias dedub, masalah
ini gampang dipecahkan, tapi sayangnya gw gak bisa SAS. Jadi terpaksa
deh bikin program VB untuk solve problem ... :-( Thx ya ...
Regards,
~subchan
________________________________
From: Programmer-VB@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Lilis Suryani
ArjaMaya
Sent: Monday, May 28, 2007 5:40 PM
To: Programmer-VB@yahoogroups.com
Subject: RE: [Programmer-VB] Tanya perintah SQL
hallo mas chan,
coba pake sintak ini
SELECT col.col1, Max(col.col2) AS col2, col.col3
FROM col
GROUP BY col.col1, col.col3;
salam
Lilis Suryani ArjaMaya
From: Programmer-VB@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Agustono, Subchan
Sent: Monday, May 28, 2007 5:29 PM
To: Programmer-VB@yahoogroups.com
Subject: RE: [Programmer-VB] Tanya perintah SQL
Thx Pian, tapi bukan itu maksudnya. Gw ralat ya biar jelas problemnya,
sourcenya kayak gini:
Source:
Col1 Col2 Col3
A 1 y1
A 2 y2
A 3 y3
A 4 y4
B 1 y1
B 2 y2
C 1 y1
C 2 y2
C 3 y3
Result:
Col1 Col2 Col3
A 4 y4
B 2 y2
C 3 y3
Thx
~subchan
______________________________________Shape Yahoo! in your own image.
Join our Network Research Panel today!
http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
<http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7>
This email is confidential. If you are not the addressee tell the sender
immediately and destroy this email
without using, sending or storing it. Emails are not secure and may suffer
errors, viruses, delay,
interception and amendment. Standard Chartered PLC and subsidiaries ("SCGroup")
do not accept liability for
damage caused by this email and may monitor email traffic.
