how to delete duplicate row from table?
if table having same record then how to delete one of them
using distinct keyword u take only unique IDs
insert values into other new table by SELECT DISTINCT * FROM TABLE1 INTO newtable then DELETE FROM TABLE1 then again insert dem back onto table1 from Newtable in similar fashion
by using distinct keyword we can do ......and another procedure also there like first we need to find out the duplicate records and then we need to remove them with the help of rownum .
delete from tbl1 a where rowid not in(select max(rowid) from tbl1 b where a.col1 = b.col1)---here col1 is the duplicate column....
use rowid for deletion of duplicate row
first alter to add use identity then use delete method this is possible I work out it
use delete from then select which table(Id) you want to delete.
Python — File Handling
Question is write a c program to print prime numbers up to n and print the largest number in array.
Achievements on Sololearn
How to draw in the console?