Looking for Receptionist

Company        Code Semantics

Website          www.codesemantics.com

Eligibility        Any Degree

Experience     0-1 Year

Location         Hyderabad

Code Semantics
Job Role: Receptionist

Job Summary :

Candidate profile:

• Should have good communication skills.

• Should be Graduate/Under Graduate.

• Should be with pleasing personality.

• Fresher’s/Experienced.

Job Description:

• Handling Front Desk

• Handling the incoming calls and carrying out general administration duties

• To liaise with other departments regarding matters arising.quirement

Address:
Code semantics India Pvt Ltd,
Plot No.62, Katriya Towers
Nagarjuna circle,Panjagutta
Hyderabad.

Contact Us:

Contact Person: Chandra Sekhar

Forward Your Resume: hr@codesemantics.com

Contact Number: 040-31009005

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