sql float保留两位

来源：互联网发布：遗传算法基本原理编辑：程序博客网时间：2024/06/14 01:47

people table schema

id
name

job table schema

id
people_id
job_title
salary

resultant table schema

job_title (unique)
average_salary (float, 2 dp)
total_people (int)
total_salary (float, 2 dp)

1.float 保留两位

SELECT   j.job_title,  cast(ROUND(SUM(j.salary) / COUNT(j),2) as float) as average_salary,  COUNT(j) as total_people,  cast(ROUND(SUM(j.salary),2) as float) as total_salary  FROM people p,job j  where     p.id = j.people_id  GROUP BY j.job_title  ORDER BY average_salary desc

2.查询结果

job_title        average_salary    total_people    total_salarypolice officer       78.53              3             235.59astronomer           77.46              6             464.78accountant           74.01              6             444.07writer               68.58              4             274.32teacher              67.9               2             135.8

阅读全文

0 0