Richard Morton a écrit :
> I have a simple query, and a problem countless people must have had, I just
> cannot work it out at the moment, I am new to MySQL; I hope you can help.
> My current statement looking at the manual.
> SELECT * FROM contacts WHERE age=MAX(age);
> I started with:
> mysql> select * from contacts where age=(select MAX(age) from contacts);
> In escence I am trying to ascertain the details of the person who is oldest.
> Any suggestions.?
This request should work:
SELECT * FROM contacts ORDER BY age DESC LIMIT 1;
Hope this helps