Walk In for Testing Resources at Subex Limited On 2nd August

Company        Subex Limited

Website          www.subex.com

Eligibility        Any Graduate - Any Specialization

Experience     0-2 Years

Location         Bangalore

Subex Limited

Job Role: Testing Resources

Job Summary :

Hi,

We are looking for Testing professionals

Competencies:

Sound knowledge on Testing with 6 Months -1.6 years of hands-on experience

Mandatory Skills: Good Knowledge in Testing, Oracle, UNIX; Good Analytical and Problem Solving skills

Good to Have: Experience in Telecom Domain (Especially on Fraud/Billing)

Please walkin on Thursday, Aug 2nd 2012 between 10 AM - 10.30 AM

Walk-In Address:
Subex Limited,
Adarsh Tech Park,
Outer Ring Road, Devarabisannalli,
Bangalore 560037, India.

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