ICICI Securities Offcampus Drive On 26th Nov in Panipat

Company       ICICI Securities Ltd

Website         www.icicisecurities.com

Eligibility        MBA

Experience     Freshers(2012/2013)

Location         Panipat

ICICI Securities Ltd
Job Role: Freshers Offcampus Drive

Job Summary :

Candidate Profile:

The candidate should be a MBA graduate from 2012 and 2013 batch students from any recognized university.

Should be willing to join immediately after 3rd sem exams at any of the locations like Jaipur/Jodhpur/Bikaner/Kota/Udaipur/Ajmer/Chandigarh/Mohali/Panchkula / Ludhiana/Jalandhar/Amritsar & Delhi.

Offcampus Drive Date On 26th November 2012(Reporting time:9.00AM)

Venue:
Panipat Institute of Engineering & Technology,
70 km Milestone,
G T Road,
Samalkha,
Panipat-132102

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