Domains of splittable email addresses

Domains of splittable email addresses

Keep rows where the entire address has a non-empty part before @ and a non-empty part after it, with no whitespace or second @. Return contact_id and the part after @ as domain, sorted by contact_id ascending.

A ordem das linhas importa

PostgreSQLv16
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid