Ed Ventures Hiring Trainee PPC

Company        Ed Ventures E-Learning Pvt Ltd

Website          www.ed-ventures-online.com

Eligibility        B.Sc - Maths,MBA/PGDM - Marketing

Experience     Freshers

Location         Hyderabad

Ed Ventures E-Learning Pvt Ltd

Job Role: Trainee PPC ( MBA - Marketing With 70%)

Job Summary :

Educational Qualifications and/ or Certifcations : MBA(Marketing) with B.Sc(Maths) preferable

Desired Skillset : Excellent Communication Skills

Additional Skillset : Sound Knowledge of Ms-word, Excel, PowerPoint.

Job Description :

Basic knowledge on the Online promotional activities and search engines.

Sound Knowledge on Ms-word, Excel, PowerPoint.

Good analytical skills & Reasoning

Excellent written and verbal communication

Dedicated & Proactive participant in analysis & Idea generation

Positively oriented

Dedication to learning

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