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/
