Subconsultas any - some - all

Julio,

ANY / SOME - algun
ALL - todos

declare @t1 table (c1 int);
declare @t2 table (c1 int);

insert into @t1 values(1);
insert into @t1 values(2);

insert into @t2 values(2);
insert into @t2 values(3);

select *
from @t1
where c1 = any (select c1 from @t2);

select *
from @t1 as T1
where exists (select T2.c1 from @t2 as T2 where T2.c1 = T1.c1);

select *
from @t1
where c1 = all (select c1 from @t2);

select *
from @t1 as T1
where not exists (select T2.c1 from @t2 as T2 where T2.c1 <> T1.c1);
GO


AMB


"Julio Glez" wrote:

Buenos das,

No entiendo al 100% las subconsultas ANY(SOME) y ALL. Alguien me podra dar
un ejemplo sencillo ya que donde he buscado no son muy claros.

Muchas gracias.