Urgently Required Research Associate for Computer Science

Job Description
Responsible for making Research Project, Synopsis, Thesis etc.
Strong analytical skills.
Must be M.tech + Ph.d in relevant field.
Should have 2 year of relevant experience.
Salary:

Negotiable
Industry:

Education / Teaching / Training
Functional Area:

Other
Role Category:

Other
Role:

Other
Keyskills:

Research Associate, Researcher, Associate, Project Associate
Desired Candidate Profile
Education:

(UG - B.Tech/B.E.) OR (PG - M.Tech - Computers) OR ( Doctorate - Ph.D - Computers)
Must Be M.tech + Ph.d
Experienced with same profile at least two year.
Company Profile
Way 2 Career
Way 2 Career is a research based career consulting company which works basically on two domains which are education and human resource.Way 2 Career is the pioneer of career consulting services..

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