kalo sintaknya begini : select distinct Nik,Nama,Saham,Tahap from tabel
seharusnya sich bisa ,,, (o o) ------------oOOo-(_)-oOOo------------ Rivian -----Original Message----- From: "Dedy" <[EMAIL PROTECTED]> To: <[email protected]> Date: Mon, 4 Jul 2005 15:14:26 +0700 Subject: Re: [Programmer-VB] [Help] Query SQL > sintax sqlnya jalan dan ga ada error tapi hasilnya null alias tidak > ada, saya hanya ingin data tersebut ditampilkan tapi tidak di group, > kalo saya cek di tabelnya record yang niknya sama ada banyak, jadi nik > yang tunggal tidak ditampilkan... > ----- Original Message ----- > From: Masim Vavai Sugianto > To: [email protected] > Sent: Monday, July 04, 2005 3:00 PM > Subject: Re: [Programmer-VB] [Help] Query SQL > > > 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] > > > > > > SPONSORED LINKS Programming languages Programmer C programming > language > Computer programming languages Java programming language C > programming language > > > ----------------------------------------------------------------------- > ------- > YAHOO! GROUPS LINKS > > a.. Visit your group "Programmer-VB" on the web. > > b.. To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service. > > > ----------------------------------------------------------------------- > ------- > > 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/
