O gitu .. nda bilang seh hehehe.
Pake database ape ?
--- Gunawan <[EMAIL PROTECTED]> wrote:
> 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
> >
>
>
>
> Wahana Programmer Groups Links
>
>
>
> Yahoo! Groups Links
>
>
> mailto:[EMAIL PROTECTED]
>
>
>
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
