你才苯呢! select distinct A from 表 group by A,B having count(*)>1
declare @a table (a varchar(100),b int) insert @a values('a',1) insert @a values('a',0) insert @a values('b',1) insert @a values('b',1) insert @a values('c',1) insert @a values('c',1)select distinct A from @a group by A,B having count(*)>1
A B a 1 a 0 a 1 a 1 b 1 b 1 b 1 c 1 c 1 c 1 -------------- 我要得到 b与c 阿
declare @a table (a varchar(100),b int) insert @a values('a',1) insert @a values('a',0) insert @a values('a',1) insert @a values('b',1) insert @a values('b',1) insert @a values('c',1) insert @a values('c',1)select a from (select * from @a group by A,B) tem group by a having count(a)<2
我要distinct A 且 B得值全部为1,若B中有0的话,就不用DISTINCT
select a from ( select a, count(a) as co from (select a,b from T group by a, b) as t group by a ) as t2 where co=1
select distinct a from table3 where not a in (select a from table3 where b=0)
pengdali(大力): 不能用这种阿,我在vb里
在哪里都没关系 这只是SQL语句
select distinct a from table3 where a in (select a from table3 where a=1)
sorry:select distinct a from table3 where a in (select a from table3 where b=1)
不对,不对,还是前面那个:select distinct a from table3 where not a in (select a from table3 where b=0)
哈!那更简单了!declare @a table (a varchar(100),b int) insert @a values('a',1) insert @a values('a',0) insert @a values('a',1) insert @a values('b',0) insert @a values('b',0) insert @a values('c',1) insert @a values('c',1)select distinct a from @a where a not in (select a from @a where b=0)
select DISTINCT A from 表
select distinct A from 表 group by A,B having count(*)>1
insert @a values('a',1)
insert @a values('a',0)
insert @a values('b',1)
insert @a values('b',1)
insert @a values('c',1)
insert @a values('c',1)select distinct A from @a group by A,B having count(*)>1
a 1
a 0
a 1
a 1
b 1
b 1
b 1
c 1
c 1
c 1
--------------
我要得到 b与c 阿
insert @a values('a',1)
insert @a values('a',0)
insert @a values('a',1)
insert @a values('b',1)
insert @a values('b',1)
insert @a values('c',1)
insert @a values('c',1)select a from (select * from @a group by A,B) tem group by a having count(a)<2
(
select a, count(a) as co from
(select a,b from T group by a, b) as t
group by a
) as t2
where co=1
(select a from table3 where b=0)
不能用这种阿,我在vb里
这只是SQL语句
(select a from table3 where a=1)
(select a from table3 where b=1)
(select a from table3 where b=0)
insert @a values('a',1)
insert @a values('a',0)
insert @a values('a',1)
insert @a values('b',0)
insert @a values('b',0)
insert @a values('c',1)
insert @a values('c',1)select distinct a from @a where a not in (select a from @a where b=0)
回复人:pengdali(大力) () 信誉:376 2003-1-30 11:06:34 得分: 30 删除
回复人:huxin1012(fox) () 信誉:100 2003-1-30 11:35:20 得分: 30 删除
回复人:CABO(白椒腊肉) () 信誉:110 2003-1-30 11:27:32 得分: 20 删除
我保证我给过了,不过我看不见,只能在管理中看见