Tuesday 21 June 2011

DELETE DUPLICATE ROWS IN TABLE QUERY

1.delete from jeg where rowid not in (select max(rowid) from jeg group by n);


2.delete from ela where rowid not in (select max(rowid)from ela group by E_id);
 
   EX:=
   DELETE FROM <TABLENAME> WHERE ROWID NOT IN (SELECT MAX(rowid)from <TABLENAME> group by (column_name))

No comments:

Post a Comment