Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Expression inside selected column name

User_Q7M0YApr 3 2022

I want to get an average salary of all employees. The query itself is rather simple:
I've been wondering: is it possible to move COUNT(salary) to selected column's title (after `AS` statement), so the name of the column will be "Average salary of 20 employees"?
I've been trying several approaches, but none of them worked. I would really appreciate any help. Thank you in advance.

Added on Apr 3 2022

#apex, #general-database-discussions, #select, #sql

2 comments

296 views