select duplicated rows by modified_date - PGSQL 9.2
Here is what I did:

CREATE TABLE junk.ja_jobs_WM (
        recurrenceid integer,
        time_job int8,
        time_job_stamp timestamp,
        dupcount integer,
        most_recent_date timestamp
);

INSERT INTO junk.ja_jobs_WM
    SELECT
                recurrenceid,
                time_job,
                TO_TIMESTAMP(time_job),
                COUNT(id) as dupcount,
                MAX(modified_date) AS most_recent_date
        FROM
                ja_jobs
        WHERE
                (NOT (recurrenceid IS NULL))
        AND
                deleted = false
        AND
                (clientid = 15288)
        AND
                creatortype = 'legacyrec'
        AND
                (time_job &gt;= EXTRACT('epoch' FROM statement_timestamp()))
        GROUP BY
                recurrenceid,
                time_job
        HAVING
                COUNT(id) &gt; 1;


This question is now closed.