I have a table with 3 columns, a record_num, a date field, and a description. In the date field there can be some rows that have a distinct date and others that have the same date. I wanted to take a look at all the rows that have dates that are at least duplicated. I thought this query would work but it produces results that include unique dates.
SELECT * FROM TIME_TABLE WHERE EXTRACT(MONTH FROM DATE_FIELD ) = EXTRACT(MONTH FROM DATE_FIELD ) AND EXTRACT(DAY FROM DATE_FIELD ) = EXTRACT(DAY FROM DATE_FIELD ) ORDER BY RECORD_NUM, DATE_FIELD, DESCRIPTION