select kode_area,count(*) from t_Penduduk
group by kode_area having count(*) > 100

sql statement di atas u/ menampilkan kode area yg memiliki 
penduduk lebih dari 100. having jg bisa digunakan utk 
mencari data yg duplikat lebih dari 1 rows.

cmiiw,



On Mon, 14 Feb 2005 09:12:40 -0000
  "yazid" <[EMAIL PROTECTED]> wrote:
> 
> 
> guys..
> 
> having di query tu buat apa sih
> contoh simpel donk
> 
> thanks
> 
> 
> 
> 
> 
> 
> -----------------------------------------------
> INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT 
> -----------------------------------------------
> IndoPB - Indonesia PB User Group 
> To Post a message, send it to: [EMAIL PROTECTED]
> To Unsubscribe,send a blank message to: 
>[EMAIL PROTECTED] 
> Yahoo! Groups Links
> 
> 
> 
> 
> 
> 
> 

========================================================================================
Akses Internet TELKOMNet-Instan beri Diskon s.d. 50 % khusus untuk wilayah Jawa 
Timur.
Informasi selengkapnya di www.telkomnetinstan.com atau hub 0800-1-INSTAN 
(467826)
========================================================================================
 


-----------------------------------------------
 INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT 
-----------------------------------------------
IndoPB - Indonesia PB User Group 
To Post a message, send it to: [EMAIL PROTECTED]
To Unsubscribe,send a blank message to: [EMAIL PROTECTED] 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indopb/

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



Kirim email ke