Urgent openings for US IT Recruiters

Company        VSoft Technologies

Website          www.vsoftconsulting.com

Eligibility        Any Graduate/MBA/PGDM - Any Specialization, HR/Industrial Relations, IT, MCA - Computers

Experience     Freshers

Location         Hyderbad

VSoft Technologies

Job Role: US IT Recruiter

Job Summary :
Job Title : US IT Recruiter

Location : Hyderabad, India

We are currently looking for Graduate/post graduate Freshers in US staffing for our Hyderabad office.

Required:

1.Excellent Communication skills - both Verbal and Written.

2. Internet Savvy.

3. Ability to Search in various search engines.

4. Willing to work Night shifts.

If your skills are a good match for our requirement, then do send me your updated resume to naveen@vsoftconsulting.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