select id,job,score from grade g1
where
g1.score>(select avg(score) from grade g2 where g1.job=g2.job group by job)
相比较的时候,后面的括号里,不把全部的查出来。之查出括号外的那条的需要的来。然后外层会一条一条查出来
select id,job,score from grade g1
where
g1.score>(select avg(score) from grade g2 where g1.job=g2.job group by job)
相比较的时候,后面的括号里,不把全部的查出来。之查出括号外的那条的需要的来。然后外层会一条一条查出来