Oracle 18c

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

create table person(id number, name varchar2(10), data varchar2(100));
insert into person(id, name, data) values(1, 'sasha', 'qweqweqwe');
1 rows affected

insert into person(id, name, data) values(2, 'sasha', 'werwerw');
1 rows affected

insert into person(id, name, data) values(3, 'dima', 'asdasdasd');
1 rows affected

insert into person(id, name, data) values(4, 'dima', 'zxczxczxc');
1 rows affected

insert into person(id, name, data) values(5, 'dima', 'dfgdfgdfg');
1 rows affected

SELECT * FROM person;


ID
NAME
DATA


1
sasha
qweqweqwe

2
sasha
werwerw

3
dima
asdasdasd

4
dima
zxczxczxc

5
dima
dfgdfgdfg


WITH cte AS ( SELECT id, 
                     name, 
                     data, 
                     ROW_NUMBER() OVER (PARTITION BY name ORDER BY data) rn 
              FROM person )
SELECT CASE WHEN rn = 1
            THEN name
            ELSE ''
            END name,
       data
FROM cte
ORDER BY cte.name, rn;


NAME
DATA


dima
asdasdasd

null
dfgdfgdfg

null
zxczxczxc

sasha
qweqweqwe

null
werwerw


SELECT CASE WHEN LAG(name) OVER (ORDER BY name, data) = name
            THEN ''
            ELSE name
            END name,
       data
FROM person
ORDER BY person.name, data;


NAME
DATA


dima
asdasdasd

null
dfgdfgdfg

null
zxczxczxc

sasha
qweqweqwe

null
werwerw

ID	NAME	DATA
1	sasha	qweqweqwe
2	sasha	werwerw
3	dima	asdasdasd
4	dima	zxczxczxc
5	dima	dfgdfgdfg

NAME	DATA
dima	asdasdasd
null	dfgdfgdfg
null	zxczxczxc
sasha	qweqweqwe
null	werwerw