select * from tablename where len(b)-len(replace(b,a,''))=0
select 字段A from 表1 where 字段A NOT IN( select distinct 字段B from 表1 )
呵呵,没有看完题目。 SELECT DISTINCT 字段A FROM 表1 WHERE (字段A NOT IN (SELECT DISTINCT 字段B FROM 表1))
select * from 表1 where 字段A not in (select 字段B from 表1 )
--生成测试数据 create table T7(id int,key1 int,key2 int)insert into t7(id,key1,key2) values(1,20,10) insert into t7(id,key1,key2) values(2,10,20) insert into t7(id,key1,key2) values(3,40,30) insert into t7(id,key1,key2) values(4,5,40) insert into t7(id,key1,key2) values(5,50,50) insert into t7(id,key1,key2) values(6,60,60) insert into t7(id,key1,key2) values(7,80,70) insert into t7(id,key1,key2) values(8,90,80) select * from t7 as a where not exists(select 1 from t7 as b where a.key1=b.key2)
create table T7(id int,key1 int,key2 int)insert into t7(id,key1,key2) values(1,20,10) insert into t7(id,key1,key2) values(2,10,20) insert into t7(id,key1,key2) values(3,40,30) insert into t7(id,key1,key2) values(4,5,40) insert into t7(id,key1,key2) values(5,50,50) insert into t7(id,key1,key2) values(6,60,60) insert into t7(id,key1,key2) values(7,80,70) insert into t7(id,key1,key2) values(8,90,80)select * from T7 where key1 not in (select distinct key2 from T7) drop table T7
用 cocosoft(pengyun) 的就对了
select distinct 字段A from 表1 where 字段A not in (select distinct 字段B from 表1)试过了,没问题!
--trycreate table T7(id int,key1 int,key2 int)insert into t7(id,key1,key2) values(1,20,10) insert into t7(id,key1,key2) values(2,10,20) insert into t7(id,key1,key2) values(3,40,30) insert into t7(id,key1,key2) values(4,5,40) insert into t7(id,key1,key2) values(5,50,50) insert into t7(id,key1,key2) values(6,60,60) insert into t7(id,key1,key2) values(7,80,70) insert into t7(id,key1,key2) values(8,90,80)select * from T7 where key1 not in (select distinct key2 from T7) drop table T7
select * from 表 a where not exists(select * from 表 where b=a.a)
这不问题不难解决 SELECT DISTINCT 字段A FROM 表1 WHERE (字段A NOT IN (SELECT DISTINCT 字段B FROM 表1))就OK了 不过,小弟我才疏学浅,没看明白--trycreate table T7(id int,key1 int,key2 int)insert into t7(id,key1,key2) values(1,20,10) insert into t7(id,key1,key2) values(2,10,20) insert into t7(id,key1,key2) values(3,40,30) insert into t7(id,key1,key2) values(4,5,40) insert into t7(id,key1,key2) values(5,50,50) insert into t7(id,key1,key2) values(6,60,60) insert into t7(id,key1,key2) values(7,80,70) insert into t7(id,key1,key2) values(8,90,80)select * from T7 where key1 not in (select distinct key2 from T7) drop table T7哪位兄台能否简单分析一下?
select * from 表1 where 字段A not in (select distinct 字段B from 表1)
select * from 表 a where not exists(select * from 表 where b=a.a)
from tablename
where len(b)-len(replace(b,a,''))=0
SELECT DISTINCT 字段A FROM 表1 WHERE (字段A NOT IN (SELECT DISTINCT 字段B FROM 表1))
create table T7(id int,key1 int,key2 int)insert into t7(id,key1,key2) values(1,20,10)
insert into t7(id,key1,key2) values(2,10,20)
insert into t7(id,key1,key2) values(3,40,30)
insert into t7(id,key1,key2) values(4,5,40)
insert into t7(id,key1,key2) values(5,50,50)
insert into t7(id,key1,key2) values(6,60,60)
insert into t7(id,key1,key2) values(7,80,70)
insert into t7(id,key1,key2) values(8,90,80)
select *
from t7 as a
where not exists(select 1 from t7 as b where a.key1=b.key2)
insert into t7(id,key1,key2) values(2,10,20)
insert into t7(id,key1,key2) values(3,40,30)
insert into t7(id,key1,key2) values(4,5,40)
insert into t7(id,key1,key2) values(5,50,50)
insert into t7(id,key1,key2) values(6,60,60)
insert into t7(id,key1,key2) values(7,80,70)
insert into t7(id,key1,key2) values(8,90,80)select * from T7
where key1 not in (select distinct key2 from T7)
drop table T7
insert into t7(id,key1,key2) values(2,10,20)
insert into t7(id,key1,key2) values(3,40,30)
insert into t7(id,key1,key2) values(4,5,40)
insert into t7(id,key1,key2) values(5,50,50)
insert into t7(id,key1,key2) values(6,60,60)
insert into t7(id,key1,key2) values(7,80,70)
insert into t7(id,key1,key2) values(8,90,80)select * from T7
where key1 not in (select distinct key2 from T7)
drop table T7
SELECT DISTINCT 字段A FROM 表1 WHERE (字段A NOT IN (SELECT DISTINCT 字段B FROM 表1))就OK了
不过,小弟我才疏学浅,没看明白--trycreate table T7(id int,key1 int,key2 int)insert into t7(id,key1,key2) values(1,20,10)
insert into t7(id,key1,key2) values(2,10,20)
insert into t7(id,key1,key2) values(3,40,30)
insert into t7(id,key1,key2) values(4,5,40)
insert into t7(id,key1,key2) values(5,50,50)
insert into t7(id,key1,key2) values(6,60,60)
insert into t7(id,key1,key2) values(7,80,70)
insert into t7(id,key1,key2) values(8,90,80)select * from T7
where key1 not in (select distinct key2 from T7)
drop table T7哪位兄台能否简单分析一下?