在已经select的记录中如何再select

[tufun]

我想在(select count(1) as cnt, sum(lab_amt) as total_amt from wty_mst groub by dt)记录集中 进行分组
类似
select sum(total_amt ) from
(select count(1) as cnt, sum(lab_amt) as total_amt from wty_mst groub by dt)
group by cnt
上句执行不了 不知道怎么写

[phantomMan]

select sum(total_amt ) from
(select count(1) as cnt, sum(lab_amt) as total_amt from wty_mst group by dt)a
group by cnt

或者这样:
select sum(total_amt ) from
(select count(1) as cnt, sum(lab_amt) as total_amt from wty_mst group by dt) as a
group by cnt

[WangZWang]

select sum(total_amt ) from
(select count(1) as cnt, sum(lab_amt) as total_amt
from wty_mst groub by dt) as tbl --加入这个表别名
group by cnt

[zjcxc]

select sum(total_amt ) from
(select count(1) as cnt, sum(lab_amt) as total_amt from wty_mst groub by dt) a --加别名
group by cnt

[denniswwh]

对，给子查询加别名