Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table funcionario (
    id      number(10) not null,
    nome    varchar(100) not null,
    empresa varchar(100) not null,
    primary key (id)
);
insert into funcionario (id, nome, empresa)
values (1, 'Mario da Silva Sauro', 'Toaldo Tulio Ltda.');
1 rows affected

insert into funcionario (id, nome, empresa)
values (2, 'Mario da Silva Sauro', 'Joao Falarz Ltda.');
1 rows affected

insert into funcionario (id, nome, empresa)
values (3, 'Homer Simpson', 'Usina Nuclear Mr. Burns');
1 rows affected

insert into funcionario (id, nome, empresa)
values (4, 'Robocop', 'OCP Enterprise');
1 rows affected

SELECT f1.nome, f3.empresa
FROM   (SELECT nome
        FROM   funcionario
        GROUP BY nome) f1
CROSS APPLY (SELECT f2.empresa
         FROM funcionario f2
         WHERE f1.nome = f2.nome
         ORDER BY f2.empresa
         OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY) f3;


NOME
EMPRESA


Homer Simpson
Usina Nuclear Mr. Burns

Mario da Silva Sauro
Joao Falarz Ltda.

Robocop
OCP Enterprise


select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0

NOME	EMPRESA
Homer Simpson	Usina Nuclear Mr. Burns
Mario da Silva Sauro	Joao Falarz Ltda.
Robocop	OCP Enterprise