Re: Efficiency; advanced/future SQL constructs

From: Heinz Huber <hhuber_at_racon-linz.at>
Date: Wed, 22 Aug 2001 09:03:48 +0200
Message-ID: <3B835954.D07C3953@racon-linz.at>

Lennart Jonsson wrote:
>
> In article <6dae7e65.0108211341.5be42f54_at_posting.google.com>, Lennart Jonsson
> says...
> >

[...]
> >
> >Something like
> >
> >select employeeID, name from Employee where salary = (select
> >max(salary) from Employee)
> >
> >should work
> >
> >/Lennart
>
> Sorry, I overlooked the "in each of my company's divisions:". Please ignore my
> suggestion

No reason to be sorry ;-) With a small adjustment, the query works the way the OP wanted it:

SELECT employeeID, name, division
FROM Employee o
WHERE salary =

(SELECT MAX(salary)

     FROM Employee i
     WHERE o.division = i.division);

hth,
Heinz Received on Wed Aug 22 2001 - 02:03:48 CDT