[tjtee]

Hi!

In mySQL there is this function asc limit 1 which will sort the sql select statement and return only 1 result.

When I do this, it says SQL Command not properly ended. Any suggestion? Thank you.

SELECT myDate order by myDate asc limit 1

[swampBoogie]

SELECT myDate from (select myDate from t 
order by myDate asc )
where rownum = 1

[tjtee]

Thank you.