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/
