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