RE: [Programmer-VB] Get no ID di SQL

[Hendikin Ferrar]

udah coba statement ini?   select top 1 id  from table_ku where id>2 order by id desc   Best regards, Hendikin Ferrar  PT. ERPSoft Solusi Mandiri The Information Technology Company http://www.erpsoft.co.id   From: Programmer-VB@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of UniqueDream Sent: Tuesday, March 07, 2006 1:18 PM To: Programmer-VB@yahoogroups.com Subject: [Programmer-VB] Get no ID di SQL saya mau tanya misalkan data saya   ID  Nama 1   Paijo 2   Bonang 3   Bendolet 4   Bendol 5   Embe   misalkan saya menghapus data dengan ID = '2' setelah dihapus, bagaimana cara nya agar saya memperoleh data return ID = '3' ?   delete * from table_ku where id = '2'   trus yang diinginkan... set @return_id = '3'   -> id dibawah data yang dihapus   mohon pencerahan.... thx b4 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 SPONSORED LINKS Programmer Indonesia Basic programming language Computer programming languages Programming languages Java programming language YAHOO! GROUPS LINKS  Visit your group "Programmer-VB" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.