Kaspon Techworks Hiring IT Business Development Executive

Company        Kaspon Techworks Pvt Ltd

Website          www.kaspontech.com

Eligibility        MBA( Marketing )

Experience     2-3 Years

Location         Chennai

Kaspon Techworks Pvt Ltd

Job Role: Business Development Executive - IT With 2-3 Years Exp

Job Summary :

• To generate quality leads that result in sales

• Develop and execute sales/Business Development proposals

• Make presentations to clients and close sales

• Build good relationships with potential and existing clients

• Work to achieve sales performance targets

• Look after the client meeting schedules with the management.

• Try to get new clients to the company for its growth

Contact Us:

Ms. Debjani

Forward Your Resume: debjani@kaspontech.com

Contact Number: 044-42125741, 9566040418

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