这样:
select A.name,A.salary,B.AvgSalary from table1 as A
inner join
(select dept,avg(salary) as AvgSalary from table1 group by dept) as B
on A.dept=B.dept
where A.salary>B.AvgSalary结果:
name salary AvgSalary
----------------------------
alan 1500.0000 1400.0000
select A.name,A.salary,B.AvgSalary from table1 as A
inner join
(select dept,avg(salary) as AvgSalary from table1 group by dept) as B
on A.dept=B.dept
where A.salary>B.AvgSalary结果:
name salary AvgSalary
----------------------------
alan 1500.0000 1400.0000
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货