analytic query

analytic query to got number of rows 

select row_number() over ( order by branch ) as rnum, a.*
  from student
 where name like '%ram%'