|
nik yang tunggal tetap di
tampilkan....?
----- Original Message -----
Sent: Monday, July 04, 2005 3:43 PM
Subject: Re: [Programmer-VB] [Help] Query
SQL
kalo sintaknya begini :
select distinct
Nik,Nama,Saham,Tahap from tabel
seharusnya sich bisa
,,,
(o o)
------------oOOo-(_)-oOOo------------
Rivian
-----Original
Message-----
From: "Dedy" <[EMAIL PROTECTED]>
To:
<[email protected]>
Date:
Mon, 4 Jul 2005 15:14:26 +0700
Subject: Re: [Programmer-VB] [Help] Query
SQL
> sintax sqlnya jalan dan ga ada error tapi hasilnya null alias
tidak
> ada, saya hanya ingin data tersebut ditampilkan tapi tidak di
group,
> kalo saya cek di tabelnya record yang niknya sama ada banyak,
jadi nik
> yang tunggal tidak ditampilkan...
> -----
Original Message -----
> From: Masim Vavai Sugianto
> To: [email protected]
>
Sent: Monday, July 04, 2005 3:00 PM
> Subject: Re:
[Programmer-VB] [Help] Query SQL
>
>
>
Kesalahan itu karena ingin menampilkan suatu summary tapi tidak
>
disertakan
> di group-nya. Kemudian, dari contoh data saya
pikir kurang pas juga.
> Saya
> pikir nanti keluaran
saham merupakan summary. Coba perintah berikut :
>
>
select NIK, Nama, Saham, Count(Tahap) as JumTahap from table group by
>
nik,
> Nama, Saham, Tahap having count(NIK) > 1
>
> Saya belum testing syntaknya tapi secara logika mestinya
demikian,
> CMIIW.
>
> Vavai
>
>
> -----Original Message-----
> From:
"Dedy" <[EMAIL PROTECTED]>
> To:
<[email protected]>
> Date: Mon, 4 Jul
2005 14:33:30 +0700
> Subject: Re: [Programmer-VB] [Help]
Query SQL
>
> > sintak sqlnya dah benar tapi ada
error isinya
> > "Colum 'Saham' is invalid in the select
list because it is not
> > contained in
> > either an aggregate function or the GROUP BY
clause"
> > ada alternatif sintak yang
lain....
> >
> > ----- Original
Message -----
> > From: "Anni"
<[EMAIL PROTECTED]>
> > To:
<[email protected]>
> > Sent: Monday,
July 04, 2005 2:08 PM
> > Subject: Re: [Programmer-VB]
[Help] Query SQL
> >
> >
> > > coba dengan query berikut
>
> > query : select * from table group by nik having
count(*)>1
> > >
> > >>
guys, ada yang tau sintak sql untuk pencarian data ganda
ga..?,
> > >> misalnya:
> >
>> Nik Nama Saham Tahap
> >
>> 001 Andi
500 1
> > >>
002 Rudi 1000
1
> > >> 003
Budi 500 1
>
> >> 001 Andi
1500 2
> > >>
>
> >> jadi nanti hasilnya:
> > >> Nik
Nama Saham Tahap
> > >>
001 Andi 500
1
> > >> 001
Andi 1500 2
> >
>>
> > >> thanx
> >
>
> > >
> > > --
> > > Regards,
> >
>
> > > Anni
>
>
>
>
> Untuk keluar dari millis ini, kirim email kosong
ke:
> [EMAIL PROTECTED]
>
>
>
>
>
> SPONSORED LINKS
Programming languages Programmer C programming
>
language
>
Computer programming languages Java programming language C
>
programming language
>
>
>
-----------------------------------------------------------------------
>
-------
> YAHOO! GROUPS LINKS
>
> a.. Visit your group "Programmer-VB" on
the web.
>
> b.. To unsubscribe from this group,
send an email to:
>
[EMAIL PROTECTED]
>
> c.. Your use of Yahoo! Groups is
subject to the Yahoo! Terms of
> Service.
>
>
>
-----------------------------------------------------------------------
>
-------
>
>
Untuk keluar dari millis
ini, kirim email kosong
ke:
[EMAIL PROTECTED]
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
YAHOO! GROUPS LINKS
|
