不好意思,没看到下半截

guest (guest)
这样行不行?
select name, salary, dept d from tb where salary > (select avg(salary) from tb where dept = d)
如果不行,可以用stored procedure.
(#28819@0)
2001-2-26 -05:00

回到话题: help! SQL assignment due tomorrow...

回到论坛: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论

URL:   
http://www.rolia.net/zh/post.php?f=0&p=28819