Dilate Technologies Hiring: Software engineer/Senior software engineer Last Date: 15th June 2013

Company:     Dilate Technologies Pvt. Ltd
Website:        www.dilatetech.com
Eligibility:     BTech/BE/MCA
Experience:   1+ yrs
Location:       Hyderabad
Job Role:       Software engineer/Senior software engineer

JOB SUMMARY:
Company Profile:
Dilate Technology is a venture with a dedicated team members having experience in BPO industry.
At Dilate Technology we are determined in going an extra mile in providing better services to all our clients across the globe. Our team members have varied experience in Customer Service, Retention, inbound and outbound, selling and up-selling, support and help desk operations, enhancement and maintenance of programs to help its customers reach their business goals.

Job Description :
.Net and SQL development

Contact Name : Khaja
Contact Details : khaja@dilatetech.com

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