ÇİFT GSS TAKİP NO OLAN HASTALAR

select p.GSS_TAKIP_NO,count(*) adet  from hastane.protokol p
where p.GSS_TAKIP_NO is not null
group by p.GSS_TAKIP_NO
having  count(*)>1


TARİH ARALIKLI

select p.GSS_TAKIP_NO,count(*) adet  from hastane.protokol p
where p.GSS_TAKIP_NO is not null
and GTARIH BETWEEN to_date('01.01.2017','dd.mm.yyyy hh24:mi:ss') and to_date('07.12.2017 23:59:00','dd.mm.yyyy hh24:mi:ss')
group by p.GSS_TAKIP_NO
having  count(*)>1