1. how to insert five rows in a table using single query(in ms-sql or oracle)2.how to delete duplicate values in a table. for example, the table containing five duplicate values(like name rani). i would like to delete all four rows in a table. but not the one row.

psingla

 Profile Answers by psingla Questions by psingla

• Mar 19th, 2010

As suggested by krishna create table test_a(a int)insert into test_a values(1)insert into test_a values(1)insert into test_a values(3)insert into test_a values(4)insert into test_a values(5)inser...

clickfreehit

 Profile Answers by clickfreehit Questions by clickfreehit

• Apr 11th, 2009

Inset data:insert into targettableselect top 5 * from sourcetabledelete data:1. select distinct * into targettable from sourcetable2. delete from sourcetable3. insert into sourcetable     select * from targettable

Answer Question  Select Best Answer