Search the Community
Showing results for tags 'oracle sql syntax'.
Found 1 result
-
Hello guys, need help regarding SQL and agregat function, here's the code: SQL> select department_id, sum(salary) place_total from employees where department_id is not null group by department_id; outputs: DEPARTMENT_ID PLACE_TOTAL ------------- ----------- 90 58000 20 19000 110 20300 50 17500 80 30100 60 19200 10 4400 Now, how to edit the current sql statement to output department_id, and max(place_total), so the output result is: DEPARTMENT_ID PLACE_TOTAL ------------- ----------- 90 58000 Anyone have an idea ? Thanks !
