Walkin Interviews for Fresher

Company        Apollo Health Street Ltd

Website          www.apollohealthstreet.com

Eligibility        Any Graduate

Experience     0-3 Years

Location         Hyderbad

Apollo Health Street Ltd

Job Role: Voice Process-ar Calling US Healthcare

Job Summary :
Walkin interviews for Freshers - Voice Process

Prerequisites:

Any Graduate; Science, Commerce , Arts preffered.

Good Communication Skills and Strong analytical skils.

Typing Speed: 20 WPM.

Familiar with Microsoft Office suite.

Willing to work in Fixed shift (5:30 PM to 2:30 AM) (Saturdays & Sundays are fixed Off)

JD:

Interacting with the US based insurance comapnies.

Analyze & follow up on the insurance cliams

Venue:
Apollo Health Street Ltd
Life Sciences building,
Apollo Hospital Complex,
Jubilee Hills, Hyderabad - 096

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