We are looking for PHP DEVELOPERS

Company        CINT Consulting Pvt.Ltd

Website          www.choicetechnologies.in

Eligibility        BTech/MBA/MCA/MSc/BSc

Experience     Freshers

Location         Hyderabad

CINT Consulting Pvt.Ltd

Job Role: PHP DEVELOPER

Job Summary :

Job guaranteed training on PHP Technology. Course duration 3 months.

Experience and background verification will be taken care.

Any graduate can apply ( b.tech/mca/mba/msc and bsc)

Eligibility pass out year: 2008 to 2011

Attractive pay packages.

willing to relocate any where in India.

Address:
CHOICE INFORMATION NETWORK TECHNOLOGIES Pvt Ltd.
Plot No: #99, 3rd Floor,
Ayyappa Society Main Road,
Madhapur, Hyderabad - 500081

Contact Us:

Ms. Sridevi

Forward Your Resume: phpjobs@choicetechnologies.in

Contact Number: 040-40058555

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