Search:

could you please explain with example query.................


Thanks

this query only possible when we are using 3 or 4 columns but when i used 100 or more column how it is possible group by all the 100 columns.
i already tried this query any way thanks for your time .

table can have a 100 column and 1000 rows. i want delete duplicate rows only. the table can have a employee data
the employee same name present in the table but different data and also present...

Table can have a following data: name age location .... Department email ---------- ---------- --------- --------- -------- arun 25 chennai .... Hr sample@sample.com arun 25 chennai .... Hr...

Actually i want delete duplicate rows in the table. If I have 100 columns and 1000 rows in the table how will delete the duplicate rows.
suppose employee table can have 100 columns and 1000 rows and...

I tried following ways

delete from colum_3 a
2 where a.rowid >
3 (select min(b.rowid) from colum_3 b
4 where a.name = b.name
5 and a.age = b.age);

but i want exact result with...

if I have 100 columns in the table?
delete duplicate rows but can not delete a record in the same name and different data.

table have
------------


SQL> select name,salary from employe order by salary;

NAME SALARY
---------- ----------
MARUTHU 2000
RAJESH 5000