Day: July 17, 2013

For even rows: SELECT *FROM (SELECT e.*,MOD(ROWNUM,2) rn FROM employees E)WHERE rn =0; For odd rows: SELECT *FROM (SELECT e.*,MOD(ROWNUM,2) rn FROM employees E)WHERE rn =1;

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;