How to get third one in a group in Oracle

how to get parent and child record in single query using oracle
oracle hierarchical query example
oracle select first record in group
how to get common records from two tables in oracle
oracle partition by
oracle hierarchical query find root
oracle hierarchical query top down
oracle with clause