enrique_aeo
asked on
oracle eliminate duplicate records
The result of this query must be stored in another table
select distinct
CodUnico,
RazonSocial,
NumeroDocumento,
CodTipoBanca,
CodGrupo,
CodCalificacionSBS,
CodFeve,
Rating,
CodSegmentacion,
CodEjecutivoNegocios,
DesEjecutivoNegocios,
LineaCredTienda
from tmp_Solicitud
but I have a problem.
The table where I insert the data is CodUnico primary key. Although I put in my query word is being shown distinct repeated CodUnico
(see picture), how I can fix this??
repeatedROW01.jpg
repeatedROW02.jpg
select distinct
CodUnico,
RazonSocial,
NumeroDocumento,
CodTipoBanca,
CodGrupo,
CodCalificacionSBS,
CodFeve,
Rating,
CodSegmentacion,
CodEjecutivoNegocios,
DesEjecutivoNegocios,
LineaCredTienda
from tmp_Solicitud
but I have a problem.
The table where I insert the data is CodUnico primary key. Although I put in my query word is being shown distinct repeated CodUnico
(see picture), how I can fix this??
repeatedROW01.jpg
repeatedROW02.jpg
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i attched the file
clientes.csv