I want to generate report in phpmysql in such a way that first detail rows display and in the bottom , sum of that detail row display on the basis of group by statement.
Select id,
Emp-name,
department,
salary,
sum(salary) as total sum for each dept
from Employee
group by department