Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Query higienizaçao
- WITH resultado AS (
- SELECT DISTINCT a.cpf FROM meutudo.cliente a
- WHERE a.uf = 'BA'
- EXCEPT
- SELECT DISTINCT cpf FROM meutudo.tb_telefone
- )
- SELECT r.cpf
- FROM resultado r
- inner join meutudo.cliente a ON r.cpf = a.cpf
- WHERE ( a.ratingportabilidade IS NOT NULL AND a.ratingportabilidade >= 37)
- order by a.ratingportabilidade desc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement