Calculating a percentage

[westmich]

Is it possible to calculate a percentage within a query?

Normally, I would handle this by running a query and than do server-side calcualtions based on the results diveded by the total number of records returned.

Select Count(Employee) as Total, Department
From Employees
Group By Department
Order By Department

[vgarcia]

What would have to be in percentages? We need some more info on your database columns/datatypes/structure. Otherwise it's just simple arithmetic nested in your query that would get a percentage.

[r937]

Is it possible to calculate a percentage within a query?

yes

select count(Employee)          as Total
     , count(Employee) * 100
      / ( select count(Employee)
            from Employees )    as DeptPercent
     , Department
  from Employees
group 
    by Department
order 
    by Department

[westmich]

Awesome