We are Hiring PHP Developers

Company        Fin Infocomm Pvt.Ltd

Website          www.fininfocomm.com

Eligibility        Any Graduate

Experience     1-2 Years

Location         Hyderabad

Fin Infocomm Pvt.Ltd

Job Role: PHP Developer With 1-2 Year Exp

Job Summary :

The incumbent must have hands-on experience on PHP 5.0, My Sql 5.0, OOPS concept in PHP, MVC Architecture, Ajax, Java Script, XHTML and CSS.

Knowledge on frameworks like Joomla, Smarty, Zend and Cake PHP will be an added advantage.

Ideal candidate should have 1 years to 2 years of experience in PHP Development.

Job Seeker must be good at analysis and coding.

Apart from technical skills; Candidate must be a team player with good communication skills.

Contact Us:

Ms. Sravanthi

Forward Your Resume: hr@fininfocom.com

Contact Number: 04064560007

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