SQL & PL/SQL

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!

Emp Table Query

440084Aug 29 2005 — edited Aug 29 2005

Hi All,

How go get the max sal, empno, empname, deptno from each dept .

Deptno, empno, empname, maxsal
10 7839 KING 5000
20 7902 FORD 3000
30 7698 BLAKE 2850
40 0 null 0

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 26 2005

Added on Aug 29 2005

10 comments

510 views