Solid Solutions International Hiring Asp.Net Programmer

Company        Solid Solutions International Private Limited

Website          www.ranksheet.com

Eligibility        Skills: ASP.NET with C# and MS-SQL Server.

Experience     1-3 Years

Location         Erode, Tamil Nadu

Solid Solutions International Private Limited

Job Role: Asp.Net Programmer

Job Summary :

We are looking for people who have 1 to 3 years development experience in ASP.NET with C# and MS-SQL Server.

The desired candidate should be willing to work in Erode location.

Responsibilities:

Need to design and develop web pages and web based applications based on the given requirements.

Apply only through - http://ranksheet.com/solidonline/jobs/352-ASPdotNet-Programmers-Wanted

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