--相同
select A.名称,B.名称 from
(Select * From Table1 Where 编号='200') A
join
(Select * From Table1 Where 编号='1') B
on A.名称=B.名称
--不相同
select A.名称 from
(Select * From Table1 Where 编号='200') A
left join
(Select * From Table1 Where 编号='1') B
on A.名称=B.名称 where B.名称 is null
select A.名称,B.名称 from
(Select * From Table1 Where 编号='200') A
join
(Select * From Table1 Where 编号='1') B
on A.名称=B.名称
--不相同
select A.名称 from
(Select * From Table1 Where 编号='200') A
left join
(Select * From Table1 Where 编号='1') B
on A.名称=B.名称 where B.名称 is null
select *
from
(Select * From Table1 Where 编号='200') A
inner join
(Select * From Table1 Where 编号='1') B
on A.名称=B.名称---and
select *
from
(Select * From Table1 Where 编号='200') A
inner join
(Select * From Table1 Where 编号='1') B
on A.名称<>B.名称
select A.名称,B.名称 from
(Select * From Table1 Where 编号='200') A
join
(Select * From Table1 Where 编号='1') B
on A.名称=B.名称
--不相同
select A.名称 from
(Select * From Table1 Where 编号='200') A
left join
(Select * From Table1 Where 编号='1') B
on A.名称=B.名称 where B.名称 is null
from table1
where 编号 in ('200','1')
and 名称 in (
select 名称
from table1
where 编号 in ('200','1')
group by 名称
having count(*)>1 ) ---当符号是大于的时候得到的是相同的纪录,当等于的时候得到的是不相同的纪录
不相同Select * From (Select * From Table1 Where 编号='200') A Where NOT Exists
(
Select * From Table1 Where 编号='1' And 名称=A.名称
)
相同
Select * From (Select * From Table1 Where 编号='200') A Where Exists
(
Select * From Table1 Where 编号='1' And 名称=A.名称
)自己搞定!