enrique_aeo
asked on
remove columns duplicate
Hi Experts,
I must stay with a single record (codigoCliente, codigoOrganizacionVenta), as I can do to remove them from my table
select * from ta_clientee t where t.codigocliente = 'D100127';
1563 D100127 EC10 BELLASI S.A.
1564 D100127 EC10 BELLASI S.A.
1565 D100127 EC10 BELLASI S.A.
select t.codigocliente,CODIGOORGA NIZACIONVE NTA, count(*)
from ta_clientee t
group by t.codigocliente,CODIGOORGA NIZACIONVE NTA
having count(*) > 1;
1 100148 EC10 3
2 100150 EC10 3
3 100277 EC10 3
4 C1000 SA10 7
5 C2000 SA10 3
create table TA_CLIENTEE
(
IDCLIENTE NUMBER not null,
CODIGOCLIENTE VARCHAR2(10) not null,
CODIGOORGANIZACIONVENTA VARCHAR2(4) not null,
NOMBRECLIENTE VARCHAR2(100) not null,
IDPAIS NUMBER not null,
IDTIPOCLIENTE NUMBER,
IDTIPOVENTA NUMBER,
I must stay with a single record (codigoCliente, codigoOrganizacionVenta), as I can do to remove them from my table
select * from ta_clientee t where t.codigocliente = 'D100127';
1563 D100127 EC10 BELLASI S.A.
1564 D100127 EC10 BELLASI S.A.
1565 D100127 EC10 BELLASI S.A.
select t.codigocliente,CODIGOORGA
from ta_clientee t
group by t.codigocliente,CODIGOORGA
having count(*) > 1;
1 100148 EC10 3
2 100150 EC10 3
3 100277 EC10 3
4 C1000 SA10 7
5 C2000 SA10 3
create table TA_CLIENTEE
(
IDCLIENTE NUMBER not null,
CODIGOCLIENTE VARCHAR2(10) not null,
CODIGOORGANIZACIONVENTA VARCHAR2(4) not null,
NOMBRECLIENTE VARCHAR2(100) not null,
IDPAIS NUMBER not null,
IDTIPOCLIENTE NUMBER,
IDTIPOVENTA NUMBER,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.