RE: getting the maximum value

SELECT name FROM myTable order by amount DESC limit 1 Would show all records sort them by amount desc and limit it to 1 record This help... --- Chris Kay Technical Support - Techex Communications Website: www.techex.com.

Re: getting the maximum value

select name, amount from myTable order by amount desc limit 1; destr0 wrote: > If I hav a table "myTable": > > id nameamount > 1john2 2joel 15 > > I want to get the name of the person with the largest amount.. but I > can't see