|
thanx guys....
caranya mr ishak yg saya pake
----- Original Message -----
Sent: Monday, July 04, 2005 3:53 PM
Subject: RE: [Programmer-VB] [Help] Query
SQL
Mo nampilin lebih dari 1 satu kan ??
Coba querynya kayak
gini :
SELECT * FROM Table a
WHERE Nik IN (
SELECT Nik
FROM Table
GROUP BY NIK
HAVING COUNT(Nik)>1
)
Kalo mau
nampilin Cuma record tertentu yang sama niknya, tambahain aja
where,
jadinya kayak gini :
SELECT * FROM Table a
WHERE Nik IN (
SELECT Nik
FROM Table
GROUP BY NIK
HAVING COUNT(Nik)>1
) AND Nik =
?
>-----Original Message-----
>From:
[email protected] [mailto:[EMAIL PROTECTED]
>On
Behalf Of Masim Vavai Sugianto
>Sent: Monday, July 04, 2005 3:01
PM
>To: [email protected]
>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
>
The contents of this e-mail may
be confidential and the unauthorized use,
copying, or dissemination of it
and any attachments to it, is prohibited.
Internet communications are not
secure and Dexa Group companies do not,
therefore, accept legal
responsibility for the contents of this message nor
for any damage caused
by viruses. The views expressed here do not necessarily
represent those of
Dexa Group companies.
Untuk keluar dari millis
ini, kirim email kosong
ke:
[EMAIL PROTECTED]
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
YAHOO! GROUPS LINKS
|
