Soft Logic Academy Hiring Business Development Executives

Company        Soft Logic Academy

Website          www.softlogic.com

Eligibility        Any Graduate

Experience     0-2 Years

Location         Chennai(KK NAGAR/ANNA NAGAR/T.NAGAR )

Soft Logic Academy

Job Role: Business Development Executive

Job Summary :

*Have to meet College Principal, Placement Officer to collect Student Database.

* Fixing Appointments with colleges for Seminar.

* Will be engaged in Business Promotional Activities.

* Need presentable Male candidates with good communication.

*Two wheeler candidates are preferred.

*Energetic and enthusiastic freshers can also apply.

No need to forward resumes.

Interested candidates can walk in directly our venue.

venue:
Soft Logic Systems
no:10,
P.T.Rajan Salai,
K.K.Nagar,
Chennai.

Contact Us:

Ms. Sarada

Forward Your Resume: hra@softlogicsys.in

Contact Number: 9171641649

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