KSAB Software Hiring Java Fresher

Company        KSAB Software

Website          www.ksabsoft.com

Eligibility        B.E(CS,EEE,ECE,IT),MCA.

Experience     Fresher

Location         Chennai

KSAB Software
Job Role: Java Fresher

Job Summary :

Job Description:

We have an urgent requirement for Java Trainees from 2009,2010,2011 Batches.

Candidate Acadamic should be above 60% from 10th,12th,UG,PG otherwise resume will not be considered

Subject line you have to mention the percentage, year of passed out..

Candidate should be B.E(CS,EEE,ECE,IT),MCA.

Should have excellent communication skill and interpersonal skill

good knowledge in Programming

Address:
48 Lb Road,
Thiruvanmiyur,
Adyar,Chennai-41.

Contact Us:

Contact Person: Saravanan

Forward Your Resume: saravanan.g@ksabsoft.com

Contact Number: 044-24522784

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