Example of Delete with limit Clause in MySQL

DELETE FROM table_name WHERE column_name = column_value LIMIT 1;

Suppose you want to delete the duplicate records from MySQL table then you can use this first count the no of row with duplicate then use -1 with limit clause for delete duplicate records.