Database

ALTER TABLE WhatEverTableName ADD ColumnB  AS (ColumnA-2);

select * into allrecs from table1 where 1 = 2  -- create any empty table
insert in to allrecs select * from table1      -- copy all your current data
truncate table table1                          -- clear your table
insert into table1 select dustinct * from allrecs -- now you just have unqiue records in your table
drop table allrecs

harsha_mec345 wrote:

can't we do without creating a new table

harsha_mec345 wrote:

soo i guess it is having some one command line answer....

DELETE FROM Emp
WHERE ROWID > (SELECT MIN(ROWID) 
               FROM   Emp);

DELETE FROM Emp a
WHERE a.ROWID > (SELECT MIN(b.ROWID) 
                 FROM   Emp b
                 WHERE  a.Field1 = b.Field1
                 AND    a.Field2 = b.Field2...);

Mika Wendelius wrote:

DELETE FROM EmpWHERE ROWID > (SELECT MIN(ROWID) FROM Emp);