Setahu saya sich untuk nomor urut itu dibikin ketika kita nyimpan data ke table,
bukan ketika ngambil, jadi querynya "insert into ......." bukannya "select *
from ........" atau lebih praktisnya dibikin autoincrement pada saat kita design
tablenya.




nur Firman <[EMAIL PROTECTED]> on 02/10/2006 01:29:46 PM

      Please respond to [email protected]

To:   [email protected]
cc:    (bcc: Toni Rahayu/IT/domino_srv)

Subject:  Re: [Programmer-VB] buat no urut di SQL Syntaks



Sorry kurang jelas yah...

maksudnya bikin no urut di data querynya
contonya 1,2,3,4,5 (auto number gitu) di querynya



Toni Rahayu wrote:
>
>
>
> Sorry nich pertanyaannya kurang terang, mau bikin nomor urut atau mau
> sortir
> data di SQL ???
>
> nur Firman <[EMAIL PROTECTED] <mailto:nurfirmann%40yahoo.co.id>>
> on 30/09/2006 08:26:46 AM
>
> Please respond to [email protected]
> <mailto:Programmer-VB%40yahoogroups.com>
>
> To: [email protected] <mailto:Programmer-VB%40yahoogroups.com>
> cc: (bcc: Toni Rahayu/IT/domino_srv)
>
> Subject: [Programmer-VB] buat no urut di SQL Syntaks
>
> Gimana yah cara buat No Urut di SQL syntaks
>
> contoh "SELECT pegawai.* FROM pegawai"
>
> kira2 ditambahin syntaks apa aja yah.....
>

__________________________________________________
Apakah Anda Yahoo!?
Lelah menerima spam?  Surat Yahoo! memiliki perlindungan terbaik terhadap spam
http://id.mail.yahoo.com






Toni Rahayu
PT. Omedata Electronics
IT Department
Hunting   : (62-22) 6030805 Ext 121
Faxs      : (62-22) 6030896
Homepage  : http://toni.rahayu.tripod.com








Wahana Programmer Groups Links

<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
    http://wahanaprogrammer.net

<*> Untuk menghubungi owner milis ini, kirim email ke:
    [EMAIL PROTECTED]

<*> Konsultasi pemrogramman bisa chat disini:
    Yahoo! Messenger: wahanaprogrammer
 
Yahoo! Groups Links

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

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/Programmer-VB/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[EMAIL PROTECTED] 
    mailto:[EMAIL PROTECTED]

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