Walk in for Dot Net Freshers From 24 and 25 Dec

Company        Arcus Infotech

Website          www.arcusinfotech.com

Eligibility        Any B.E/B.TECH

Experience     Freshers

Location         Hyderabad

Arcus Infotech
Job Role: .Net Freshers

Job Summary :

Strong programming skills on c#,.Net
Strong knowledge in .Net (VB,ASP,C-Sharp)
Strong SQL Programming knowledge in SQL Server 2005/08
Strong Programming Knowledge in HTML,CSS,Java Script.
Excellent analytical and Problem solving skills.
Good communication skills(oral&Written).

Interested candidates can directly walkin to our venue on 24-12-2012 to 25-12-2012 between 10 AM to 5 PM

Venue :

2nd floor,Lal Bungalow,Ameerpet,
Opposite green Park hotel.
Hyderabad-16
Phone:040-40033838,23418787

Contact Us:

Contact Person: Sandhya

Contact Number: 9392729797

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