coba pake syntax ini : select t.a, t.b, row_NUMBER() over(PARTITION BY t.a ORDER BY t.a) c from test1 t ORDER BY t.A;
Nik ----- Original Message ---- From: dark pluto <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, November 28, 2007 4:24:50 PM Subject: [indo-oracle] create_number saya punya data seperti berikut: ------------ --------- --------- 00001 A0001 00001 A0001 00002 A0001 00003 A0002 00003 A0002 00003 A0002 ------------ --------- --------- -- saya ingin hasil query spt berikut: 00001 A0001 1 00001 A0001 2 00002 A0001 1 00003 A0002 1 00003 A0002 2 00003 A0002 3 kira2 gmanah yach caranya udah coba-coba tapi belum berhasil thanks ____________ _________ _________ _________ _________ ________ Bergabunglah dengan orang-orang yang berwawasan, di di bidang Anda! Kunjungi Yahoo! Answers saat ini juga di http://id.answers. yahoo.com/ [Non-text portions of this message have been removed] ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs [Non-text portions of this message have been removed]
