Write a SQL query to display alternate records from a table?
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;
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;