|
SELECT Table1.Nik, Table1.Nama,
count(Table1.Nik)
FROM Table1
group by Table1.Nik, Table1.Nama
having
count(Table1.Nik) > 1
coba deh .... mudah2 an bener....
----- Original Message -----
Sent: Monday, July 04, 2005 3:54 PM
Subject: Re: [Programmer-VB] [Help] Query
SQL
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]
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
YAHOO! GROUPS LINKS
|
