That leaves us with the answer from Gleb Paharenko, except the insert query should be "insert into memp select min(salary) from emp;"
... and the select should be:
select emp.* from emp,memp where salary=m;
He would get all employes with the lowest salary, as opposed to:
select * from emp order by salary limit 1;
... wich would only list one "random" of the employees with the lowest salary.
"...an employee whose salary is the lowest" ... sounds like he wants ONE employee...?
-- Roger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]