Help in SQL ORACLE query

Question

Column DEPENDENCY: T - Titular; E - Esposa; F - Filhos; FA - Filho Adotivo

As table above, how do I bring data only of CEP S that are divergent as the CEP of the Holder:

Titular Admilson has 2 children with different zip code, as well as titular Marcelo.

Abusing a little more, it is possible to bring the data of the holder and right below the data of the children with the divergent strains?

Answer 1

You can do it like this:

select
    tabela.familia as familia_titular,
    nao_titular.familia as familia_nao_titular,
    tabela.nome,
    nao_titular.nome,
    nao_titular.cep
from
    tabela,
    (
        select 
            familia,
            cep
        from 
            tabela 
        where
            dependencia <> 'T'
    ) as nao_titular
where
    tabela.familia = nao_titular.familia
    and tabela.dependencia = 'T'
    and tabela.cep <> nao_titular.cep;