duplicate rows
I have to delete the duplicate rows by checking the created date . Means if there are two rows for particular key_id , I have to remove the older record by checking the created date .The latest record data I have to keep in table . Here the key_id and created is the composite primary key.
Here IS MY TABLE DESCRIPTION
SQL> desc prod.f0784
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 key_id                               NOT NULL NUMBER(20)
 rate                                 NOT NULL NUMBER(38)
 location                                      NUMBER(6)
 member                                        NUMBER(6)
 created_date                         NOT NULL DATE
Please help help for sql query
Thanks!