create table #t1(id int)
go
insert into #t1(id) values(1)
insert into #t1(id) values(2)
insert into #t1(id) values(3)
insert into #t1(id) values(4)
insert into #t1(id) values(5)create table #t2 (id int)
go
insert into #t2(id) values(1)
insert into #t2(id) values(3)
insert into #t2(id) values(4)select *
from #t1
where id not in (select distinct id from #t2)drop table #t1,#t2
go
insert into #t1(id) values(1)
insert into #t1(id) values(2)
insert into #t1(id) values(3)
insert into #t1(id) values(4)
insert into #t1(id) values(5)create table #t2 (id int)
go
insert into #t2(id) values(1)
insert into #t2(id) values(3)
insert into #t2(id) values(4)select *
from #t1
where id not in (select distinct id from #t2)drop table #t1,#t2
解决方案 »
- 请教exec调用存储过程参数太多的问题...
- asp+SQL,想插入一个值等于一个网址加插入时获得的自动编号的值
- 求一条SQL语句
- 高手帮忙:怎么去除一个数据库的某个MDF文件??
- 求助SQL 查询
- SQL难题。。。〔5〕
- 数据库新手请教~~~~~~
- Login failed. The maximum simultaneous user count of 1 licenses for this 'Standard Edition' server has been exceeded....
- isql 的问题??
- 请教SQL达人的减法问题!
- 软件加密的最佳方案------加密狗!!!
- 怎么把一张表的一个text类型的字段,导到另一张表的一个text类型的字段
union
select * from 库2 where **=5
go
insert into #t1(id) values(1)
insert into #t1(id) values(2)
insert into #t1(id) values(3)
insert into #t1(id) values(4)
insert into #t1(id) values(5)create table #t2 (id int)
go
insert into #t2(id) values(1)
insert into #t2(id) values(3)
insert into #t2(id) values(4)SELECT DIstinct #t1.ID FROM #t1,#t2 WHERE #t1.ID not in (SELECT * FROM #t2)drop table #t1,#t2
create table #t1(id int)
go
insert into #t1(id) values(1)
insert into #t1(id) values(2)
insert into #t1(id) values(3)
insert into #t1(id) values(4)
insert into #t1(id) values(5)create table #t2 (id int)
go
insert into #t2(id) values(1)
insert into #t2(id) values(3)
insert into #t2(id) values(4)SELECT ID FROM #t1 WHERE ID not in (SELECT * FROM #t2)drop table #t1,#t2