Jump to content

how to get other collums with agregat function


Recommended Posts

Hello guys,


I posted this Question in MYSQL thread accidentally, so I'll try to ask the same here since I use Oracle RDBMS.


Need help regarding SQL and aggregate function.

I would like to do max function (or some join or something else), to get max value of column, and other column with it also.

Here's the code:




select department_id, sum(salary) place_total from employees
where department_id is not null group by department_id;



Previous query outputs this:

------------- -----------
           90       58000
           20       19000
          110       20300
           50       17500
           80       30100
           60       19200
           10        4400



Now, how to edit previous sql statement so it can output department_id, and max(place_total), so the output result is:


------------- -----------
           90       58000




Anyone have an idea, how to do this ?

Thanks !

Link to post
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.