Amdocs Development Center India Hiring SME Trainee

Company        Amdocs Development Center India Pvt Ltd

Website          www.amdocs.com

Eligibility        B.Tech/B.E/MCA

Experience     Freshers

Location         Pune

Amdocs Development Center India Pvt Ltd

Job Role: SME Trainee

Job Summary :

Eligibility Criteria :

Must be BE / B.Tech (IT/ Electronics &Telecommunication /Electronics & Communication /Comp Sc. ONLY ) OR MCA Graduates ONLY

Percentage criteria - 60% (Aggregate of all Semesters) & above throughout academics, individually in 10th, 12th & Graduation, Postgrad (if applicable).

Year of passing qualifying degree 2012 year ONLY

Should not have any Year Down / Backlog during - 10th, 12th, Grad, PG.

Should not have attempted the Amdocs test in the past 15 months

How to find out Max Salary from each department

You can find maximum salary for each department by grouping all records by DeptId and then using MAX() function to calculate maximum salary in each group or each department. SQL Query: SELECT DeptID, MAX(Salary) FROM Employee GROUP BY DeptID. This questions become more interesting if Interviewer will ask you to print department name instead of department id, in that case you need to join Employee table with Department using foreign key DeptID, make sure you do LEFT or RIGHT OUTER JOIN to include departments without any employee as well. Here is the query

List the emps who joined before 1981.

Answer: select * from emp where hiredate < (’01-jan-81’);

SQL Info

Search This Blog