sundeep

• Nov 21st, 2006

 

 u mean to remove the repeated records?

for that the query is

select distint<colname> from <tablename>

preethi

• Jan 9th, 2007

 

To remove distinct rows from a table use this

delete from table_name where column_name in (select distinct(column_name) from table_name);

If u want unique values

select distinct (column_name) from table_name ;

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Nov 28th, 2010

 

 delete from table_name where column_name in (select distinct(column_name) from table_name);