Re: Problema SQL

On 2/16/07, Oswaldo Hernández <listas(at)soft-com(dot)es> wrote:
> > select valor
> > from valorescomunes
> > group by valor
> > having count(valor) = (select count(distinct clave) from valorescomunes);
> >
>
>
> Por cierto, se me ocurre que si en la tabla tienes valores nulos posiblemente falle, tenlo en cuenta
>

bueno, como null <> null nunca saldra null como valor comun

--
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook