Looking for Catalog Analyst

Company       Goldfox India Online Services Pvt.Ltd

Website          www.goldfoxindia.com

Eligibility        Any graduation (only local Karnataka graduates can apply )

Experience     0-6 Years

Location         Bangalore

Goldfox India Online Services Pvt.Ltd

Job Role: Catalog Analyst

Proficiency : Kannada, English, Hindi

Salary : 8k -12k Pm.(After 3 months salary will be 15k+insentive)

Candidate Profile:
Candidates who has Karnataka driving license or PAN card can apply

Last date for applying is 24 December 2012, till evening 10 pm

Call latter will be send on the basis of first come first serve basis.

Contact Us:

Contact Person:Mr. Sanjeev kumar

Forward Your Resume: careers@goldfoxindia.com

Contact Number: 080-60660036

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