原博客地址:http://www.cnblogs.com/ylemzhang/archive/2013/10/29/3393831.html
-- t1表数据 2,3
-- t2表数据 1,2,3,4
-- '>all' 表示:t2表中列n的数据大于t1表中列n的数据的数,结果只有4.
select
*
from
t2
where
n >
all
(
select
n
from
t1 )
--4
select
*
from
t2
where
n >
any
(
select
n
from
t1 )
--3,4
select
*
from
t2
where
n >
some
(selectn
from
t1)
--3,4
select
*
from
t2
where
n =
all
(
select
n
from
t1 )
--无数据
select
*
from
t2
where
n =
any
(
select
n
from
t1 )
--2,3
select
*
from
t2
where
n =
some
(selectn
from
t1)
--2,3
select
*
from
t2
where
n <
all
(
select
n
from
t1 )
--1
select
*
from
t2
where
n <
any
(
select
n
from
t1 )
--1,2
select
*
from
t2
where
n <
some
(selectn
from
t1)
--1,2
select
*
from
t2
where
n <>
all
(
select
n
from
t1 )
--1,4
select
*
from
t2
where
n <>
any
(
select
n
from
t1 )
--1,2,3,4
select
*
from
t2
where
n <>
some
(
select
n
from
t1)
--1,2,3,4
set
nocount
off