Dear all,

In MySQL, I can limit the result rows like:
select aField from aTable order by aDate limit 1;
The result will be limited to 1 row.

How can I archieve the same in Firebird?


Thanks.
Michael