Sql code to delete duplicate entries | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Sql code to delete duplicate entries

consider the student.table stdno. name 10. Vijay 11. Naveen 10. Deepak 13. Arun 11. Aravind I want to delete oly the duplicate entry from the above table

28th Nov 2017, 1:53 PM
Vijay
1 Answer
0
I suggest to look into PL-SQL, which is not complicate if you already know sql and have some basic knowledge of programming, where you can set a cursor with the query, and a condition that looks for duplicates.
1st Dec 2017, 10:00 PM
Roberto Guisarre
Roberto Guisarre - avatar