Write a query to get the required data regarding employees.

Question

Anonymous · Accepted Answer

You can use & modify below query -
select e.ename, dep.loc from emp e,
(select d.deptno, d.dname, d.loc from dept d,
(select deptno dno, count(*) ct from emp group by deptno order by deptno desc) dn
where rownum = 1 and dn.dno = d.deptno) dep where e.deptno = dep.deptno order by e.ename;

Anonymous · Answer

I think query will be like  given below. Check or change a bit for your requirements.

select EMP.ENAME, lc.LOCNAME from employee emp, company org, location lc where emp.cID = ORG.CID and org.locID = lc.locID
and lc.locID in (
select place.locID from (
select loc.locID, count(*) ct from employee e, company c, location loc where e.cID = c.cID and c.locID = loc.locID
group by loc.locID order by ct desc) place where rownum = 1);

Enjoy :)

Anonymous · Answer

These people in ADP have been in such a comfort zone that they don't like to pick more capable people who can challenge their capability disturbing their comfort zone & rest who cares about the profits of the company till the time salary is getting credited in the account with less or no work. So continue to show-off & keep capable people away.

Anonymous · Answer

I had this interview & ADP recruiter doesn't have a courtesy to provide me the  feedback, even after a request to her.

ADP

ADP Interview Question

Interview Answers

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches