Oracle offset

SELECT * 
FROM   (SELECT ROWNUM raw_rnum_, raw_sql_.*
        FROM   (SELECT DISTINCT processos.*, 
                                movimentacoes.created_at 
                FROM   processos 
                       inner join tp_solicitacoes 
                               ON tp_solicitacoes.id = 
                                  processos.tp_solicitacao_id 
                       inner join movimentacoes
                               ON movimentacoes.id = 
                                  processos.movimentacao_id 
                WHERE  tp_solicitacoes.identify IN ( 1, 2, 3 ) 
                ORDER  BY movimentacoes.created_at DESC) raw_sql_ 
        WHERE  ROWNUM <= 50) 
WHERE  raw_rnum_ > 0;