Hi,

Try select first 1 aField from .....

Sudheer


--- "hkuser2001 <ibo@...>" <ibo@...>
wrote:
<HR>
<html><body>


<tt>
Dear all,<BR>
<BR>
In MySQL, I can limit the result rows like:<BR>
select aField from aTable order by aDate limit 1; <BR>
The result will be limited to 1 row.<BR>
<BR>
How can I archieve the same in Firebird?<BR>
<BR>
<BR>
Thanks.<BR>
Michael<BR>
<BR>
<BR>
<BR>
</tt>


<br>
<tt>
To unsubscribe from this group, send an email to:<BR>
ib-support-unsubscribe@egroups.com<BR>
<BR>
</tt>
<br>

<br>
<tt>Your use of Yahoo! Groups is subject to the <a
href="http://docs.yahoo.com/info/terms/">Yahoo! Terms
of Service</a>.</tt>
</br>

</body></html>


__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com