Dia kan dah bilang... bilangnya gene... Kondisi Gwe gini: Pake Visual Basic 6.0 SP 6.0 ActiveX Database MySQL 5.0 Tanpa komponent ADODC
----- Original Message ----- From: "Erwam Suaj" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, February 26, 2008 2:20 PM Subject: Re: [Programmer-VB] Tanggapan: Masalah pada SELECT DISTINCT up. bung Erwan >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 >> >>
