SELECT C.DEPTNAME D.NUM
FROM B,
(SELECT DEPTID,COUNT(DEPTID) NUM
FROM B
GROUP BY DEPTID) D
WHERE B.DEPTID= D.DEPTID这样是不是可以啊??
没有试验您试试
FROM B,
(SELECT DEPTID,COUNT(DEPTID) NUM
FROM B
GROUP BY DEPTID) D
WHERE B.DEPTID= D.DEPTID这样是不是可以啊??
没有试验您试试
select c.deptName,count(*)
from b,c
where b.deptID=c.deptID
group by c.deptName;
from (select distinct c.deptName,c.deptID,b.issID
from b,c
where b.deptID=c.deptID) t,a
where t.issID=a.issID
group by t.deptName
select c.deptName,count(*)
from b,c
where b.deptID=c.deptID
group by c.deptName;
(select t.deptid,max(t.rid) as fcount (select b.deptid,row_number over (partition by b.deptID order by rownum) as rid from b) t) s,c
where s.deptid = c.deptID