>> 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
| "Dedy" <[EMAIL PROTECTED]>
Sent by: [email protected] 04/07/2005 02:33 PM
|
|
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]
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
