sql alternative for ranking functions

All,

How would one define an sql alternative for the ranking functions? Let's say we use:

select name,

       rownum over (partition by ctime)
from table
group by name;

Is there a standard sql equivalent to this?

Cheers,
Marc Received on Mon Jun 03 2002 - 07:58:24 CDT