BPO Walkins for Bengali Voice Process

Company Name: Hinduja Global Solutions Ltd.
Web Site: http://www.teamhgs.com

Hinduja Global Solutions, part of the multi-billion dollar conglomerate - Hinduja Group, excels in providing outsourcing solutions that include Back Office Processing, Contact Center services and customized IT solutions to its global clientele comprising several Fortune 500 Companies.

Walkin Interview from 13th June to 21st June from 10 AM.

Walkins for Bengali Voice Process

Experience: 0 to 2 yrs.
Job Description:
=> Candidates who are flexible with voice process where he/she has to receive or make calls from / to the customers regarding the product/service.
=> Reporting to team leader

Address: HGS House, #614,
Vajpayee Nagar, Bommanahalli,
Hosur Road, Bangalore BANGALORE,Karnataka,India.

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