sql - Postgresql ROUND 函数

Question

我尝试四舍五入这个查询，但我的结果有 10 位小数。我已经尝试了 DECIMAL() 函数、CAST()ROUND() 并且它仍然不起作用。我需要 2 位小数。

select type, count(id) filter ( where type ilike 
'private') as "number of applications",
   count(id) filter ( where type ilike 'private' and 
 type ilike 'paid') as "number of paid applications",
(count(id) filter ( where type ilike 'private' and 
status ilike 'paid')
     /round(count(id) filter (where type ilike 'private')) * 
(100)) as "percent of paid applications"
from applications
where type ilike 'private'
group by type
union
select type, count(id) filter ( where type ilike 
'business') as "number of applications",
      count(id) filter ( where type ilike 'private' and 
status ilike 'paid') as "number of paid applications",
      (count(id) filter ( where type ilike 'business' and 
status ilike 'paid')
       /round(count(id) filter (where type ilike 
'business')) * (100)) as "percent of paid applications"
from applications
where type ilike 'business'
group by type

Answer 1

round(yourvalue,2) 应该如你所愿

例如select round(12.1451124569,2) 一个具有 10 位小数精度的数字作为第一个参数返回 12.15