Skip to main content

How To Compute MAX(AVG(Field)) in SQL

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 

Labels:

Comments

Post a Comment

Popular posts from this blog

Cannot access a disposed object. A common cause of this error is disposing a context that was

  Cannot access a disposed object. A common cause of this error is disposing a context that was resolved from dependency injection and then later trying to use the same context instance elsewhere in your application. This may occur if you are calling Dispose() on the context, or wrapping the context in a using statement. If you are using dependency injection, you should let the dependency injection container take care of disposing context instances. Object name: 'PropertyContext'.  public class CustomerHub : Hub     {         public readonly ICustomerService _customerService;         private readonly IServiceScopeFactory _serviceScopeFactory;         public CustomerHub(ICustomerService service, IServiceScopeFactory serviceScopeFactory)         {             _customerService = service;             _serviceScopeFactory = serviceSco...
Post a Comment
Read more

ahara-nidra-bhaya-maithunam

आहर निद्रा भय मैथुनं च सामान्यमेतत पशुभिर्नराणाम् धर्मो हि तेषाम् अधिको विशेषो धर्मेण हीना पशुभिः समाना ahara-nidra-bhaya-maithunam ca samanyam etat pashubhih naranam dharmo hi tesham adhiko vishesho dharmena hina pashubhih samanah Hunger, sleep,fear and sexual desire are the instincts which are common between mankind and beasts (animals). .It is especially 'Dharma;' that mankind possesses additionally, and a person bereft of 'Dharma' is like a beast, “Eating, sleeping, fearing, and mating are the four principles of animal life. These are common both to animals and to human beings. But religion is the extra function of the human being. Without religion, human life is no better than animal life.” -from Mahabharata
Post a Comment
Read more