0

I would like to ask how can I delete duplicate records in MySQL from my fingerprint table.

I need to delete any record if found the same created_date AND created_time AND employee_number

Thanks, Jassim

Improve this question
2
  • possible duplicate of delete duplicate entries in table Commented Sep 18, 2014 at 6:40
  • Removed psql tag. psql is the PostgreSQL command-line client, and there's no sign this question has anything to do with it Commented Sep 18, 2014 at 8:08

1 Answer 1

Reset to default
2

If you have auto increment key then,

DELETE f1 FROM fingerprint f1, fingerprint f2 WHERE f1.autoincreament < f2.autoincreament AND f1.created_date = f2.created_date AND f1.created_time = f2.created_time AND f1.employee_number = f2.employee_number

Refer to link

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.