SELECT inst, count(*)
FROM student, team
WHERE student.student_code = team.student_code(+) AND leibie=1
GROUP BY inst
FROM student, team
WHERE student.student_code = team.student_code(+) AND leibie=1
GROUP BY inst
解决方案 »
- ORACLE数据库运行一段时间后,应用程序和PLSQL登陆都提示12560错误.急急急^^
- 业务表和数据字典表关联(可以为null)
- 请大虾帮助,找出一行中的最大值并得到该值的字段名
- 熟悉oracle和sqlserver的大佬进,如何在删除表的同时删除被引用约束?
- 两个表之间的计算?
- 怎样一次输出一个记录变量中的所有内容?
- 为何在只装了oracle client 的机了上,没法运行 rman;
- 关于Replace替换回车换行符号无效!(是oracle一大弊端 还是我不了解)
- Oracle 10g 触发器中如何获取Date类型字段的变化值,要有时分秒
- SQLDeveloper启动后一直在“等待编辑器初始化”
- 小弟自己写的触发器,请问错在那里?
- ******这条SQL为什么不能执行,解决立即给分*****
FROM student, team
WHERE student.student_code = team.student_code AND leibie=1
GROUP BY inst
having count(*)>=0
FROM student, team
WHERE student.student_code = team.student_code AND leibie=1
GROUP BY inst
union
select distinct inst,0
from student
where not exists(
select 1 from team where student.student_code = team.student_code AND leibie=1
)
楼楼上的改成:
SELECT inst, count(*)
FROM student, team
WHERE student.student_code = team.student_code(+) AND leibie(+)=1
GROUP BY inst
就可以了,
但我还想求 是普通会员或是黄金会员的人数
WHERE student.student_code = team.student_code(+) AND leibie(+) IN {1,2}
就不可以了,
WHERE student.student_code = team.student_code(+) AND leibie(+) IN {1,2}
就不可以了