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

Reply via email to