×

Loading...

very simple select * from employee t1 where t1.empsalary > (select avg(empsalary) from employee t2 where t2.depname = t1.depname )

tuantuan (团团)
(#28820@0)
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技术讨论