In response to Greenhorn :
> Hi,
>
> Can someone please help me with this duplicate query.
>
> I'm trying to:
>
> 1. Return duplicates only. (without including the first valid record), and
I will try to help you. Assuming this table:
test=*# select * from greenhorn order by id;
id | ins
Hi,
Can someone please help me with this duplicate query.
I'm trying to:
1. Return duplicates only. (without including the first valid record), and
2. Return as duplicate if the difference between a.inspection_time
and b.inspection time is under 5 minutes.
Here's the query string I'm using to
