一个SQL查询的问题(在线等) select JNO from spj where Sno='s1'不是很明白你的意思,不知上面是不是你想要的 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select jno from spj where pno in (select pno from spj where sno='s1') group by pno,jno having sum(1)=(select count(distinct pno) from spj where sno='s1')--测试:create table #spj(SNO varchar(10),PNO varchar(10),JNO varchar(10))insert #spj values('s1','p1','j1')insert #spj values('s1','p1','j3')insert #spj values('s1','p1','j4')insert #spj values('s1','p2','j2')insert #spj values('s2','p3','j1')insert #spj values('s2','p3','j2')insert #spj values('s2','p3','j4')insert #spj values('s2','p3','j5')insert #spj values('s2','p5','j1')insert #spj values('s2','p5','j2')insert #spj values('s3','p1','j1')insert #spj values('s3','p3','j1')insert #spj values('s4','p5','j1')insert #spj values('s4','p6','j3')insert #spj values('s4','p6','j4')insert #spj values('s5','p2','j4')insert #spj values('s5','p3','j1')insert #spj values('s5','p6','j2')insert #spj values('s5','p6','j4')select jno from #spj where pno in (select pno from #spj where sno='s1') group by pno,jno having sum(1)=(select count(distinct pno) from #spj where sno='s1')godrop table #spj--sum(1)等于:count(*) 求记录数 存储过程中用到的replace函数问题 一个查询语句 下面这个函数有这个错误,不知为什么? 错误444:函数中含有的select 语句无法向客户端返回数据 怎么高效率的读满足条件的最新数据 sql server存储过程动态删除问题 select 'b'+bh from jg在存储过程中怎么写???? 用exec执行的 sql server 2000 查询指定行 这样的SQL语句该怎么写啊? 同步复制表的问题 (老大快出来) 怎么样在不同的数据库中操作SQL语句! 如下事务处理为何不能提交?烦请各位 很简单的问题,却错了:(,帮我看看,谢谢
create table #spj(SNO varchar(10),PNO varchar(10),JNO varchar(10))
insert #spj values('s1','p1','j1')
insert #spj values('s1','p1','j3')
insert #spj values('s1','p1','j4')
insert #spj values('s1','p2','j2')
insert #spj values('s2','p3','j1')
insert #spj values('s2','p3','j2')
insert #spj values('s2','p3','j4')
insert #spj values('s2','p3','j5')
insert #spj values('s2','p5','j1')
insert #spj values('s2','p5','j2')
insert #spj values('s3','p1','j1')
insert #spj values('s3','p3','j1')
insert #spj values('s4','p5','j1')
insert #spj values('s4','p6','j3')
insert #spj values('s4','p6','j4')
insert #spj values('s5','p2','j4')
insert #spj values('s5','p3','j1')
insert #spj values('s5','p6','j2')
insert #spj values('s5','p6','j4')
select jno from #spj where pno in (select pno from #spj where sno='s1') group by pno,jno having sum(1)=(select count(distinct pno) from #spj where sno='s1')
go
drop table #spj--sum(1)等于:count(*) 求记录数