Walkin for Tech Support Officer On 30th,31st Oct at Orion Edutech

Company        Orion Edutech

Website          www.orionedutech.com

Eligibility        Graduates/UG

Experience     0-1 Year

Location         Chennai

Orion Edutech
Job Role: Tech Support Officer/Hardware/Networking analyst

Job Summary :

Job Description:

Trouble shooting / Network Issues / hardware design etc

We are National Skill development Corporation Partner (NSDC) & Member of NASSCOM.

We Are hiring for Top Corporate Companies

Candidates will be trained through NSDC support and Placed.

Salary : Negotiable

Interview Process: Aptitude, HR Rounds

Walkin on 30th and 31st Oct 2012

Venue:
Orion Edutech Pvt Ltd,
12A, 174/321, 2nd Floor
Doshi Gardens Shopping Mall
Arcot Road,
Vadapalani,
Chennai - 600026

Contact Us:

Contact Person: Nithya / Aarthi

Forward Your Resume: vadapalani@orionedutech.com

Contact Numbers: 9566111317 / 9282412061 / 044-64605250/51

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