SELECT column1, column2, ROW_NUMBER() OVER (PARTITION BY column1 ORDER BY column2) column3 FROM table
CMIIW, AH dark pluto wrote: > > 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/ > <http://id.answers.yahoo.com/> > > [Non-text portions of this message have been removed] > >
