Home » SQL & PL/SQL » SQL & PL/SQL » Re: Employee who earns the highest salary
Re: Employee who earns the highest salary [message #1507] Tue, 07 May 2002 06:50
K. Balasubramanian
Messages: 10
Registered: April 2002
Junior Member
Hai,
Please do it as follows

select max(salary) from employee a,dept b where
a.dept=b.dept and dept='&dep'

If u want to view it deptwise then

select a.dept,max(salary) from employee a,dept b where
a.dept=b.dept and dept='&dep'
group by a.dept

I hope so u'r asking this.

Bye

From

K. Bala
Previous Topic: Migration Problem (very Urgent)
Next Topic: Suppress zero with a blank
Goto Forum:
  


Current Time: Fri Mar 29 08:07:48 CDT 2024