hemantachhami19 · January 16, 2022 04:01
diff --git a/postgres_fetch records at 10 second interval b/postgres_fetch records at 10 second interval
 select distinct t1.*
 from payments t1
     join payments t2
          on t2.created_at between (t1.created_at - interval '10 second')
                 and (t1.created_at + interval '10 second')
              and t2.id != t1.id
 order by id
	select distinct t1.*
	from payments t1
	join payments t2
	on t2.created_at between (t1.created_at - interval '10 second')
	and (t1.created_at + interval '10 second')
	and t2.id != t1.id
	order by id