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
<*> 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/
