sybase row_number equivalent function

[937989]

I am migrating oracle sql to sybase. in my oracle row_number function in nor working in my sybase.
can anyone please tell me the equivalent function in sybase.

Thanks in advance

 

[NatanielB]

Hi there,
Have you tried doing this?

select
security_id, side , count(*)
from
trade
group by security_id, side



testing and qa info