about 8 years ago
You can delete the duplicate row without using the temporary table. You can use the self join concept.
Suppose we have person table contain 3 columns named id, name, and city.
INSERT INTO person(id,name,city) VALUES
Now we have to delete the duplicate row from table.
You can see the duplicate record from following query:
select * from person p1, person p2 where p1.id > p2.id;
Now you can delete duplicate recored using the following query.
delete from person p1, person p2 where p1.id > p2.id;
Hope this will help you.
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2022 FindNerd.com. All rights reserved.
Sign up using