By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table movies (id int, name varchar(15), genre varchar(31));
insert into movies values
(1, 'A', 'fantasy'),
(2, 'A', 'medival'),
(3, 'B', 'sci-fi'),
(4, 'C', 'comedy'),
(5, 'C', 'sci-fi'),
(6, 'C', 'romanse'),
(7, 'D', 'horror');
with
m as (select name, min(id) id from movies group by name),
sel as
(
SELECT * FROM m ORDER BY id OFFSET 1 ROWS FETCH NEXT 2 ROWS ONLY
)
SELECT movies.* FROM sel JOIN movies ON movies.name = sel.name ORDER BY movies.id;
| id | name | genre |
|---|---|---|
| 3 | B | sci-fi |
| 4 | C | comedy |
| 5 | C | sci-fi |
| 6 | C | romanse |