Re: Extract same datetime records

KK wrote:
> Hi Frank,
>
> The call_time doesn't have any specific value to compare.
>
> I just want the duplicated call_time records only. It is something
> related with self join.
>
> Thanks.

SELECT column1, column2, COUNT(*)
FROM ...
WHERE ...
GROUP BY column1, column2
HAVING COUNT(*) > 1;

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)