You could also do it like this:
select min(id) from emp;
Roger Baklund wrote:
[EMAIL PROTECTED] wrote:
I need to get all the details of an employee whose salary is the lowest. I can do like this in Oracle
select * from emp where id = (select min(id) from emp).
Can we have any alternative in MySQL for the above query, as sub queries are not supported in MySQL 4.0.21
There is no need for a subquery in this case:
select * from emp order by id limit 1;
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
