Virtual 01 Notepad

Suppose you have the following table You need to find which Department has the maximum average salary in a single query you can easy ly find average value of each department using aggregate function AVG() But how to select only the department having the maximum average salary.In SQL SERVER USE    select top 1 DeptName,MAX(MyAvg) AVARAGE_SALARY FROM(   select AVG(salary) as MyAvg,DeptName  from [SalaryTable] group by Deptname   ) temp   GROUP BY DeptName   order by AVARAGE_SALARY  desc 

Register asp.net again....will solve the issue. Go to Visual Studio Command Prompt, And register asp.net as windows\microsoft.net\Framework[.Net version num]\aspnet_regiis.exe -i AND I had this issue with Windows Server 2012 with ASP .NET 4.5 you can't use aspnet_regiis.exe, and just have to install ASP .NET 4.5 via the Add Roles and Features Wizard: and use correct application pool