Accenture immediate openings for freshers and experience On August, septembar 2015

Company Website: https://www.accenture.com/

Company Profile:
Accenture plc is a multinational management consulting, technology services, and outsourcing company. Its incorporated headquarters have been in Dublin, Ireland since September 1, 2009. About Accenture Accenture is a global management consulting, technology services and outsourcing company, with more than 323,000 people serving clients in more than 120 countries. Combining unparalleled experience, comprehensive capabilities across all industries and business functions, and extensive research on the world's most successful companies, Accenture collaborates with clients to help them become high-performance businesses and governments. The company generated net revenues of US$30.0 billion for the fiscal year ended Aug. 31, 2014. Its home page is www.accenture.com.

Job Position name: Various vacancies

Reference: Naukri.com

Job Type: IT/Software. BPO., KPO
Job Details: Accenture is Hiring for Freshers -Bangalore
Shift: Flexible to work in US shifts

Eligible DetailsOnly B.com,BBM,BBA, M.com
Good knowledge in accounts
Good communication skills
No BE/Btech, No Regular MBA

ProceduresIf this is the opportunity that you are looking for,

then please send your updated resume to sulakshan.banerjee@accenture.com or Contact -8884157159

Contact : Sulakshan Telephone : 8884157159 Email: sulakshan.banerjee@accenture.com Website:http://www.careers.accenture.com/India

Required Experience: 0 - 1 YearsIndustry TypeBPO / Call Centre / ITESRoleAssociate/Senior Associate -(NonTechnical)Functional AreaITES, BPO, KPO, LPO, Customer Service, OperationsEducation

Eligible Education:
UG - B.Com - Commerce, B.B.A - Management

PG - Post Graduation Not Required, M.Com - Commerce

Doctorate - Other Doctorate

Available Compensation: Not disclosed

Work Place: Bengaluru/Bangalore

Selection process: interview

Apply mode: Online

How to find second highest salary in SQL

There are many ways to find second highest salary of Employee in SQL, you can either use SQL Join or Subquery to solve this problem. Here is SQL query using Subquery :

SQL Query:

select MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) from Employee );

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