关于聚合函数和groupby的使用
在Oracle中
想要查询多个字段 但是只按照其中一个字段分组时 可将聚合函数查询放在from后嵌套子查询 sql示例如下
SELECT p1.id,
p1.code,
p2.fname,
p2.fidcard,
p2.fareacode,
p3.area,
p2.phone,
p2.sumpremium,
nvl(p2.fpremium, 0)
FROM insuremain p1,
plantinglist p2,
(select sum(case calculateflag when ‘Y’ then area else 0 end)as area,fidcard from plantinglist group by fidcard) p3
where p1.code = p2.code
and p3.fidcard = p2.fidcard
order by p1.id desc, p2.fname, p2.fidcard