clear markdown feedback
≡
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3799226 fiddles created (41707 in the last week).
select version();
version()
8.0.27
…
 hidden batch(es)
create table tab (patient varchar(10), visit int, physician varchar(10)); insert into tab values ('a', 1, 'id_1'), ('a', 2, 'id_2'), ('a', 3, 'id_1'), ('a', 4, 'id_3'), ('b', 5, 'id_1'), ('b', 6, 'id_2'), ('c', 7, 'id_1'), ('c', 8, 'id_2'), ('c', 9, 'id_3'); select * from tab;
✓
✓
patient visit physician
a 1 id_1
a 2 id_2
a 3 id_1
a 4 id_3
b 5 id_1
b 6 id_2
c 7 id_1
c 8 id_2
c 9 id_3
…
 hidden batch(es)
select patient, visit from (select patient, visit, row_number() over (partition by patient order by visit) rn from (select patient, min(visit) as visit from tab group by patient, physician) t1 ) t2 where t2.rn = 3
patient visit
a 4
c 9
…
 hidden batch(es)