select name,topcount from ( select a.objectid,a.name as name, count(b.title) as topcount from table_name_1 a, table_name_2 b where a.objectid = b.xxxid group by a.object_id,a.name )
select a.name as name, count(b.title) as topcount from test_01 a, test_02 b where a.objectid = b.xxxid group by a.name
以上在sql server中做過測試
select 表一.Name,count(*) from 表一 inner join 表二 on 表一.ObjectId=表二.XXXId group by 表一.ObjectId order by 表一.ObjectId
from (
select a.objectid,a.name as name,
count(b.title) as topcount
from table_name_1 a,
table_name_2 b
where a.objectid = b.xxxid
group by a.object_id,a.name
)
count(b.title) as topcount
from test_01 a,
test_02 b
where a.objectid = b.xxxid
group by a.name
inner join 表二 on 表一.ObjectId=表二.XXXId
group by 表一.ObjectId
order by 表一.ObjectId