Coba ini
"SELECT ID, TGLIN, JAMIN
FROM (
SELECT ID, TGLIN, JAMIN, RANK() OVER (ORDER BY JAMIN DESC) AS RANK
FROM (SELECT DISTINCT ID, TGLIN, JAMIN ROM TABLW WHERE ID='" & .Fields("ID")
& "')) WHERE RANK = 1"
SELECT TOP 1 hanya dikenal di MS Product... CMIIW
----- Original Message -----
From: "Erwam Suaj" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, February 26, 2008 11:47 AM
Subject: Re: [Programmer-VB] Tanggapan: Masalah pada SELECT DISTINCT up.
bung Erwan
> Itu mestinya bisa bro.. fungsi top 1 kan untuk
> mengambil 1 saja dari sekian record yang mestinya
> tampil.. kemungkinan filternya yang salah (where)
>
> Kalo Mas Nugroho pake distinct tidak akan bisa karena
> jam antara row 1 dengan2 beda.. distinct itu berlaku
> pabila semua fieldnya antara row 1 dan 2 sama persis.
>
> Coba kamu buka dulu filternya muncul nda bro, pake
> query analyzer dulu
>
> --- Gege Nugroho <[EMAIL PROTECTED]> wrote:
>
>> Trims bro dah meluangkan waktu njawab....
>>
>> But, it;s won't work...
>> Datanya malah ngga masuk sama sekali.
>>
>> Bingung dah....
>>
>> Erwam Suaj <[EMAIL PROTECTED]> wrote:
>> Pakenya Select Top 1 ID, TglIn, JamIn
>> From Tabel Where ID='" & .Fields("ID") & "'"
>>
>> --- Gege Nugroho <[EMAIL PROTECTED]> wrote:
>>
>> > Guys...
>> > Gwe punya masalah lage (yang kesekian kalinya
>> > :-)....)
>> >
>> > Kondisi Gwe gini:
>> > Pake Visual Basic 6.0 SP 6.0 ActiveX
>> > Database MySQL 5.0
>> > Tanpa komponent ADODC
>> >
>> > Saat nyimpen gwe punya data :
>> > ID TglIn JamIn
>> > 01 2008-02-20 15:00:00
>> > 01 2008-02-20 15:01:59
>> >
>> > Nah gwe mau data itu yang kesimpen cuman satu ajah
>> > (yang mana ajah) dengan statement ini, malah masuk
>> > dua-duanya : xM = "Select Distinct ID, TglIn,
>> JamIn
>> > From Tabel Where ID='" & .Fields("ID") & "'"
>> >
>> > Kalo gwe pake ini, data ngga masuk sama sekali :
>> > xM = "Select Distinct ID, TglIn From Tabel Where
>> > ID='" & .Fields("ID") & "'"
>> >
>> > Juga kalo pake ini, ngga masuk juga : xM = "Select
>> > Distinct ID From Tabel Where ID='" & .Fields("ID")
>> &
>> > "'"
>> >
>> > Jadi intinya bagaimana menggunakan statement
>> > SELECT DISTINCT ini dimana hanya menyortir satu
>> data
>> > ID dan TGLIN ajah.
>> >
>> > Ato ada statement lain yah?
>> > Trims yo...
>> >
>> > PS : Sori kalo tatabahasa gwe rada njelimet...
>> > hehehe
>> >
>> > dariyangbingungngambilsatudata
>> >
>> >
>> > Regards
>> > Gege Nugroho
>>
>>
>> .
>>
>>
>>
>>
>> Regards
>> Gege Nugroho
>>
>> ---------------------------------
>> Be a better friend, newshound, and know-it-all with
>> Yahoo! Mobile. Try it now.
>
>
>
>
> ____________________________________________________________________________________
> Looking for last minute shopping deals?
> Find them fast with Yahoo! Search.
> http://tools.search.yahoo.com/newsearch/category.php?category=shopping
>
