Urgent openings for Front Office Executive, Female Counselor

Company        VERTEX SOFT(A GROUP OF VLS SOLUTIONS PVT LTD)

Website          www.vertexsoft.co.in

Eligibility        Degree (Graduation)

Experience     0-1 Year

Location         Hyderabad

VERTEX SOFT(A GROUP OF VLS SOLUTIONS PVT LTD)

Job Role: Front Office Executive / Female Counselor (Only Female)

Job Summary :

Counseling experience is an added advantage

Good communication skills Mandatory

Telle calling experience

Good Interpersonal skills

Drafting letters

High Motivation Skills

Internet browsing knowledge

Address:
VERTEX SOFT (A Group of VLS Solutions Pvt Ltd)
Flat No: 102, Padmasagar Apts
Opp: Bowl o China Resutarent
S.R Nagar Community Hall
S.R Nagar, Hyderabad

Contact Us:

Mr. Raghu

Forward Your Resume: hr@vertexsoft.co.in

Contact Number: 040 - 6454 4838

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