Urgent requirement for Oracle hr techno functional position

Oracle HR Techno-Functional position in Duluth, MN

This is initially a 2+ month engagement

     7+ years of experience in Oracle EBS.
    Strong experience in the HR module, specifically Time & Labor and Payroll.
    Experience on Oracle R12.
    Knowledge of fast formulas, impacts, retropay, and reports.
    Must have to ability to ramp up quickly.
    Able to work independently.
    Must have excellent communication skills.

If you are indeed interested in the position, please send your resume in word format along with your desired all-inclusive rate, work status and availability. This is an on-site only position. We will be presenting the best candidates at the best rates. In addition, this client also has a technical opening on the Financials side as well. Thank you for your time!

Very Truly,

Sam Williams - Recruiting Manager

Direct: 646-499-5264

swilliams@itbtalent.com
www.itbrainiac.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