Walkin for Process Associate Data Analyst On 30th Nov

Company        Technosoft Global Services Pvt Ltd

Website          www.technosoftcorp.com

Eligibility        Graduation in any stream

Experience     0-1 Year

Location         Bangalore

Technosoft Global Services Pvt Ltd
Job Role: Process Associate - Data Analyst

Job Summary :

Designation: Process Associate

Experience: 0 to 1year

Job Location: Bangalore

Notice Period: Immediate

Cab: Pick up and Drop back

Opening(s): 10

Job Description:

*Should have completed his/her graduation in any stream.

*Should have knowledge in MS Office

*Should have excellent Communication Skill.

*Should have good Attitude

We would very much appreciate the candidate ready to join immediately

WALK-IN TIMING : 11 AM - 3 PM ON 30th November 2012

Venue Details:

Technosoft Corporation (Near Shopper Stop)

# 111, Mezzanine Floor

Brigade Court, 5th Block

Koramangala Industrial Layout

Bangalore 560095

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