i want maximum of average salaries for each job type among all departments from the default employee table in oracle 9i. if possible in a single query without creating any tables.
Printable View
i want maximum of average salaries for each job type among all departments from the default employee table in oracle 9i. if possible in a single query without creating any tables.
Have table schema?
the table consists of ename,eno,deptno,job,salary.