SkillSign Assessment Solutions Hiring Marketing Executive

Company        SkillSign Assessment Solutions

Website          www.skillsign.com

Eligibility        Any Graduate

Experience     Fresher

Location         Bangalore

SkillSign Assessment Solutions

Job Role: Marketing Executive

Job Summary :

SkillSign is a leading provider of Online Assessment Platform to Educational institutes, Coaching Centers, recruiters and corporates.

We are looking for creative, motivated and hungry-for-knowledge people to help grow our brand. If you think you can take up the challenge of being part of a team who is building a world class product, come join us.

Skills needed are Good Communication Skills both written and verbal.

Knowledge of internet is mandatory.

Candidates who are in Bangalore can only apply.

How to Apply

Mail your resume with subject line “Job Application for Marketing Executive”.

Contact Us:

HR

Forward Your Resume: career@skillsign.com

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