Remove repeated lines in all respects in Oracle [closed]

Understanding that you want to delete duplicate records from the database, but keeping one (1) of them, I suggest using rowid .

ROWID is a pseudo-column that returns the address of a record, structurally you will not see it, but it's there. It uniquely identifies a row within a table.

In the script below we have:

• A sub-query fetching all the minor rowid of each repeated grouping;

• A delete command in all records that are not in the minimum collation done in the subquery;

Script:

delete from cadastro
where rowid not in
     (select min(rowid)
      from cadastro
group by nome, id, email, sexo);

With this, duplicates will be deleted leaving at least one of each.

Note: You should never store a rowid in your tables as a (unique) key value.     

In sql server, the method below works. In oracle I think it looks similar:

select *
into #table
from(   select nome = 'JOAO', id=1234, email='[email protected]', sexo='m'
        union all
        select nome = 'JOAO', id=1234, email='[email protected]', sexo='m'
        union all
        select nome = 'manuel', id=1237, email='[email protected]', sexo='m') t

   ;WITH cte AS (
        SELECT  *, 
                row_number() OVER(PARTITION BY nome,id,email,sexo ORDER BY nome,id,email,sexo) AS rn
        FROM #table
    )
    DELETE cte WHERE rn > 1

select * 
from #table

drop table #table

Use distinct .

Select Distinct * From Tabela;

See working in SQL Fiddle.