could you please explain with example query.................
Thanks
Type: Posts; User: sureshkumar.mtech; Keyword(s):
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