select a.*,b.*
from
(select username,month,sum(salary)
from t_salary_detail
group by username,month) a
inner join
(select username,month,sum(salary)
from
t_salary_detail group by username,month) b on a.username=b.username;
select a.*,b.*
from
(select username,month,sum(salary)
from t_salary_detail
group by username,month) a
inner join
(select username,month,sum(salary)
from
t_salary_detail group by username,month) b on a.username=b.username;