Home » SQL & PL/SQL » SQL & PL/SQL » Employee who earns the highest salary
Employee who earns the highest salary [message #1504] Tue, 07 May 2002 05:37 Go to next message
Kagore
Messages: 1
Registered: May 2002
Junior Member
Given Table structure:
Emp(empno, ename,job,sal,comm,hiredate, mgr, deptno)
Dept(deptno, dname, location)

How do you select the name of the employee who earns the highest salary for a job type in a department?
Please Help....

Report message to a moderator

Re: Employee who earns the highest salary [message #1546 is a reply to message #1504] Fri, 10 May 2002 21:48 Go to previous message
Anjan kumar chand
Messages: 2
Registered: May 2002
Junior Member
select max(sal) *from emp;

Report message to a moderator

Previous Topic: Oracle Training Referrals Requested
Next Topic: sql*Plus Login
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 12:11:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.