• Post Reply Bookmark Topic Watch Topic
  • New Topic

Help with query  RSS feed

 
avihai marchiano
Ranch Hand
Posts: 342
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey,

lets say that i have managers and employees
i want to get all managers that the sum of their employees salery is bigger than 100.

I try this:


select manager.id
from manager left join manager.employees
where having sum (employees.salery) > 100
group by manager.id

but i get the syntax is incorrect.

Can you please advice?

10x
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!