susah2 amat, pake TOP 1, nested select, ga perlu susah2, kan pake MySQL tuh,
dah ada solusinya
gini aja....
select * from Tabel Where ID='" & .Fields("ID" ) & "'" LIMIT 0,1
LIMIT tuh sintaknya gini, LIMIT (mulai record ke..),(jumlah record yang di
ambil)
pasti bisa....
oh iya, kalo JAMIN itu ga terlalu di pedulikan, kenapa tetap dimasukan datanya.
Itu tabel, kalo ga pake primary key, pasti semua fieldnya primary key. Cukup
set ID dan TGLIN aja sebagai primary key...
mudah2an berhasil
----- Original Message ----
From: Erwam Suaj <[EMAIL PROTECTED]>
To: [email protected]
Sent: Tuesday, February 26, 2008 2:20:07 PM
Subject: Re: [Programmer-VB] Tanggapan: Masalah pada SELECT DISTINCT up. bung
Erwan
O gitu .. nda bilang seh hehehe.
Pake database ape ?
--- Gunawan <jgun98.milis@ gmail.com> 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" <erwansyah2001@ yahoo.com>
> To: <Programmer-VB@ yahoogroups. com>
> 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 <gegenugroho@ yahoo.com> wrote:
> >
> >> Trims bro dah meluangkan waktu njawab....
> >>
> >> But, it;s won't work...
> >> Datanya malah ngga masuk sama sekali.
> >>
> >> Bingung dah....
> >>
> >> Erwam Suaj <erwansyah2001@ yahoo.com> wrote:
> >> Pakenya Select Top 1 ID, TglIn, JamIn
> >> From Tabel Where ID='" & .Fields("ID" ) & "'"
> >>
> >> --- Gege Nugroho <gegenugroho@ yahoo.com> 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
> >> >
> >> > dariyangbingungngam bilsatudata
> >> >
> >> >
> >> > 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:Programmer-VB- fullfeatured@ yahoogroups. com
>
>
>
____________ _________ _________ _________ _________ _________ _
Never miss a thing. Make Yahoo your home page.
http://www.yahoo. com/r/hs
<!--
#ygrp-mkp{
border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;}
#ygrp-mkp hr{
border:1px solid #d8d8d8;}
#ygrp-mkp #hd{
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;}
#ygrp-mkp #ads{
margin-bottom:10px;}
#ygrp-mkp .ad{
padding:0 0;}
#ygrp-mkp .ad a{
color:#0000ff;text-decoration:none;}
-->
<!--
#ygrp-sponsor #ygrp-lc{
font-family:Arial;}
#ygrp-sponsor #ygrp-lc #hd{
margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
#ygrp-sponsor #ygrp-lc .ad{
margin-bottom:10px;padding:0 0;}
-->
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean,
sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
..bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a{
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc{
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o{font-size:0;}
..MsoNormal{
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
..replbq{margin:4;}
-->
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
