You can use this Query select id, ROW_NUMBER( ) OVER (PARTITION BY
ID ORDER BY ID) cou from taji Thanks Tajidner On Fri, Mar 11, 2011 at 11:08 AM, gayathri Dev <gd0...@gmail.com> wrote: > Hi All, > > Is there any analytical function that can achieve this ? > > I have a column whose values are as below: > > ID > ---- > > 22 > 22 > 33 > 33 > 44 > 44 > > I want to rank them as: > > 22 - 1 > 22 - 2 > 33 - 1 > 33 - 2 > 44 - 1 > 44 - 2 > > Thanks in advance. > > ~G > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
