Gayathri, When 'ranking', all values which are equal must have equal ranks. You asked for ranking, but what you have show in your example is simply 'numbering'.
Tajinder's solution will give you numbering if that is what you really want. Mike On Fri, Mar 11, 2011 at 12:08 AM, tajinder singh <taji.si...@gmail.com>wrote: > 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 > -- 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
