Walk In at Elico Ltd for Design Engineers On 25th

Company        Elico Limited

Website          www.elico.co

Eligibility        B.Tech/B.E. - Mechanical, Diploma - Mechanical

Experience     0-3 Years

Location         Hyderabad

Elico Limited

Job Role: Design Engineers

Job Summary :

Fresher with Diploma / B.Tech - 70%( 2011 - 2012 passouts)

Note: Pro- E & Auto- Cad is compulsory.

Preferably Male candidates with 0-3 years exp. can Apply.

Candidates Should be very good in Auto Cad and Pro - E.

Should have good technical drawing knowledge.

Should have knowledge of Design and development of product.

Should be interested for a product base atmosphere.

Should be energetic, positive and should have learning attitude.

Should have command over current job profile.

If Interested Directly walk-in on 25.07.12 at 2.00PM.

Venue:
Elico Limited,
B:90, A.P.I.E.,
Near Bharath Nagar Railway Station,
Sanath Nagar,
Hyderabad: 18.

CLICK HERE TO MORE DETAILS & APPLY

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