coba pake Query select min(Item),min(name) from Newtable group by left(item,1)
----- Original Message ---- From: Indra WS <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, October 8, 2007 11:58:42 AM Subject: [Programmer-VB] Query SQL, HEleppp dear All, tolong bantu saya, saya sedang bingung untuk membuat query SQL, dimana saya ingin SELECT kode barang saya hanya 1 per alphabet depannya. bisa tolong bantu saya?? Contoh: ITEM CODE NAME ============ ======== A0001 Ani A0002 Ati A0003 Adi B0001 Beni B0002 Budi C0001 Cica D0001 Dodi D0002 Dudu hasil Query nya adalah ITEM CODE NAME ============ ======== A0001 Ani B0001 Beni C0001 Cica D0001 Dodi yang penting 1 untuk per Alphabet depannya Tolong dibantu Om-Om VB Master.... Terima kasih Don't let your dream ride pass you by. Make it a reality with Yahoo! Autos. Send instant messages to your online friends http://uk.messenger.yahoo.com
