这个程序没有 结果输出 帮帮忙 use tsg
select cno
from borrow
group by cno,bname
HAVING bname='计算方法'AND bname='组合数学'
select cno
from borrow
group by cno,bname
HAVING bname='计算方法'AND bname='组合数学'
解决方案 »
- HELP
- 简单的用c#向数据库里写用户信息,遇到个小问题望大家帮忙解决
- 如何防止msde中的文件copy后,被附加?
- 各位:SQL SERVER 2000 升级到SP4 会引起什么问题吗?
- 请高人指点,group by ...with rollup所带字段不能超过十个,怎么办啊? 在线等候中。。。
- 急!急!急!哪位好心人帮帮小弟啊!!!万分感谢!!!
- .net面试中遇到的一个问题,希望那位高手能帮忙解决!!!
- 高分求解: sql mail 成功发出可收不到,怎么解决??为什么?(欢迎大家来讨论,来者有分)
- 触发器问题!请高手给个帮助!
- 如何在SQL7中存储图象
- sql对导入的excel有行数限制吗
- win xp sp3系统下安装 SIMATIC_SQL_SP3a 下的问题
from borrow
group by cno,bname
HAVING COUNT(bname)=2
select cno
from borrow
group by cno,bname
HAVING count(1)>2
select cno
from borrow
group by cno,bname
HAVING count(1)=2
from borrow
group by cno
HAVING COUNT(DISTINCT bname)=2更改
select cno
from borrow
where bname='计算方法' or bname='组合数学'
group by cno
HAVING count(1) = 2
楼主,记得结贴哦
select cno from borrow
group by cno
having count(1)=2
use tsg
select cno
from borrow
where bname='计算方法'AND bname='组合数学'
group by cno
HAVING count(*)=2