This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

有错了

guest:guest

这样呢？
select name, salary, dept d from tb where salary > (select avg(salary) from tb group by d)

(#28822@0)
Last Updated: 2001-2-26
This post has been archived. It cannot be replied.

Report