guest (guest)
select name, salary, dept d from tb where salary > (select avg(salary) from tb where dept = d)
如果不行,可以用stored procedure.
2001-2-26 -04:00
This post has been archived. It cannot be replied.
Page address has been copied. To share, click to copy page address.
Share Online by QR Code

Back To Topic: help! SQL assignment due tomorrow...

Back To Forum: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论