Blog - Our findings and learning

You no need to try to learn something. With the experience of trying, we learn what works and how it works. We share the same with you to learn from our experience.

Write a query to display manager and employees under them?

select manager,count(employee), rtrim(xmlagg(xmlelement(e,employee||’,’)).extract(‘//text()’),’,’) as “Employees under the Manager” from (select e2.first_name manager,e1.first_name employee from employee e1,employee e2 where e1.reporting_to=e2.employeeid) group by manager;

Read More »
Scroll to Top