We are looking for Customer Service Executive

Company        Chanda Software Development And Consulting Services Pvt. Ltd.

Website          www.chandagrp.com

Eligibility        Any Degree

Experience     0-1 Year

Location         Hyderabad

Chanda Software Development And Consulting Services Pvt. Ltd.
Job Role: Customer Service Executive (Inbound & Outbound)

Job Summary :

-Candidate will be responsible for handling the outbound and inbound processes

-Candidate should have presentation and convincing skills

-Candidate should have a positive and should be goal oriented

-Fluent in English, Hindi and Telugu languages

-Candidate should be flexible to work in US and UK shifts

Qualification : Any Degree

Contact Us:

Contact Person: Sujitha

Forward Your Resume: hr@chandagrp.com

Contact Numbers: 8985933839, 040-65909999

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