[Pgsql-ayuda] Contar Registros Duplicados
Eladio Rodriguez
elarod01@hotmail.com
Fri, 21 Mar 2003 08:10:06 -0600
<html><div style='background-color:'><DIV>saludos.</DIV>
<DIV> </DIV>
<DIV>mira si esto es el resultado que buscas:</DIV>
<DIV> </DIV>
<DIV><FONT color=#0000f0 size=2>
<P>select</FONT><FONT color=#000000 size=2> clave</FONT><FONT color=#0000f0 size=2>,</FONT><FONT color=#000000 size=2> serie</FONT><FONT color=#0000f0 size=2>,</FONT><FONT color=#000000 size=2> </FONT><FONT color=#007ff0 size=2>count</FONT><FONT color=#0000f0 size=2>(*)</FONT><FONT color=#000000 size=2> </FONT></P>
<P><FONT color=#0000f0 size=2>from</FONT><FONT color=#000000 size=2> (tu_tabla)</FONT></P>
<P><FONT color=#0000f0 size=2>group</FONT><FONT color=#000000 size=2> </FONT><FONT color=#0000f0 size=2>by</FONT><FONT color=#000000 size=2> clave</FONT><FONT color=#0000f0 size=2>,</FONT><FONT color=#000000 size=2> serie </FONT></P>
<P><FONT color=#0000f0 size=2>having</FONT><FONT color=#000000 size=2> </FONT><FONT color=#007ff0 size=2>count</FONT><FONT color=#0000f0 size=2>(*)</FONT><FONT color=#000000 size=2> </FONT><FONT color=#0000f0 size=2>></FONT><FONT color=#000000 size=2> </FONT><FONT color=#800000 size=2>1;</FONT></P>
<P><FONT color=#800000 size=2>eladio rodriguez</FONT></P>
<P><FONT color=#800000 size=2>costa rica.</P></FONT></DIV></div><br clear=all><hr>MSN 8 helps <a href="http://g.msn.com/8HMGEN/2743">ELIMINATE E-MAIL VIRUSES. </a> Get 2 months FREE*.</html>