how to remove the duplicate rows without the help of rowid and primary key.

Answer 1

what about using DISTINCT?

Answer 2

@natalya distinct will not remove the data from the table, it will just displays the results without duplicate. distinct will not alter table .

Answer 3

delete from EmpDup where EmpID in(select EmpID from EmpDup group by EmpId having count(*) >1).......... in this query EmpDup is table name and EmpID column having duplicate values. using this query u can delete duplicate values

Answer 4

thanq