AndresVargas

Hi!, my nickName is zodman, im a Computer science Engineering. love the FLOSS and FreeSoftware. Python ninja and php coder. On left my love Aisha and me.

Interest links
seen more



Powered by Django.
ene. 22, 2010

el contrario del distinct

cuando haces un:

select distinct campo1 from conjunto

te salen todos los campo1 no repetidos...

ahora quiero el inverso y saber cuantos estan repetidos

/* duplicados inverso al distinc */
select * from conjunto
where idregistro in (
select idregistro,count(1) from conjunto
group by camporepetido
where count(1)>1
)
codigo macabro
Direct Link | Comment (0)