Transport Logistics for Engineering Industry minimum 15 years Experiance is required

Job Description
* Well based Exp. and expertise in transport logistics incl.:
o Land, sea , air freight, packing, warehousing
o ODC Transports
o Taxes & duties, World Wide customs affairs
* Experienced expert for Project and Transport Logistics
Salary:

INR 10,00,000 - 20,00,000 P.A
Industry:

Industrial Products / Heavy Machinery
Functional Area:

Supply Chain, Logistics, Purchase, Materials
Role Category:

Senior Management
Role:

Head/VP/GM-SCM/Logistics
Keyskills:

Logistics, Transportation
Desired Candidate Profile
Education:

(UG - Any Graduate - Any Specialization) AND (PG - Any Postgraduate - Any Specialization) AND ( Doctorate - Any Doctorate - Any Specialization, Doctorate Not Required)
Graduate with P.G Diploma
Working Exp on SAP
Company Profile
Excel Infotechs
http://www.excel-group.in
Client :: A Leading Heavy Engineering Industry (MNC)

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