Bisa menggunakan perintah :

"select kota from tb_nya group by kota"

Nanti kota yang sama akan tampil satu aja.

rgd,

--- [EMAIL PROTECTED] wrote:

> dear All..
> 
> saya ada pertanyaan lagi :
> 
> Saya punya field kota
> 
> Kota 
> 
> Jakarta
> Bekasi
> Bogor
> Jakarta
> Jakarta
> 
> Jika saya ingin munculkan nama kota tapi jika ada 2
> atau lebih yg sama 
> dimunculkan 1 saja. 
> 
> Kota
> 
> Jakarta
> Bekasi
> Bogor
> 
> Gimana syntak sqlnya ? 
> 
> 
> Best Regards ..
> 
> Haris


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


------------------------ Yahoo! Groups Sponsor --------------------~--> 
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~-> 

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/
 



Kirim email ke