Hi,
I have a table SalaryInfo as below
Salary | Department | Level
50 | RD| Director
3 | Maintenance| Groundsman
...
I want to know what level in each department makes the highest salary
and how much that salary is? Something like:
SELECT Salary, Level, Department FROM
PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 24, 2003 12:00 PM
Subject: SUBSELECT QUESTION?
Hi,
I have a table SalaryInfo as below
Salary | Department | Level
50 | RD| Director
3 | Maintenance| Groundsman
...
I want to know what level in each department makes
Ben Margolin [EMAIL PROTECTED] wrote:
I am new to subselects, and what I really want is to do them in an update,
but the following shows a simpler select, that also doesn't seem to work as I
think it should. Advice? Do I just misunderstand how subselects are actually
executed?
(This is on
I am new to subselects, and what I really want is to do them in an update,
but the following shows a simpler select, that also doesn't seem to work as I
think it should. Advice? Do I just misunderstand how subselects are actually
executed?
(This is on mysql version 4.1.0-alpha-max-nt.)
First,
: subselect question... shouldn't this work?
I am new to subselects, and what I really want is to do them in an
update,
but the following shows a simpler select, that also doesn't seem to work
as I
think it should. Advice? Do I just misunderstand how subselects are
actually
executed