|
tetap ga bisa Errornya " Line 1 : Incorrect syntax
near ' )'
ada solusi yang lain...
----- Original Message -----
Sent: Monday, July 04, 2005 2:44 PM
Subject: Re: [Programmer-VB] [Help] Query
SQL
>> 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
kalau kaya
gini?
select * from
table where ( select count(nama) from table having count(nama)>1)
Salam
Ronald Irawan
Pt. Sanghiang
Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
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]
>
>
> Yahoo!
Groups Links
>
>
>
>
>
>
Untuk keluar dari millis ini, kirim email kosong
ke:
[EMAIL PROTECTED]
Yahoo! Groups
Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To
unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of
Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
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
|
