| Subject | Re: [ib-support] How to limit result rows like MySQL? |
|---|---|
| Author | Sudheer Palaparambil |
| Post date | 2002-12-12T04:48:44Z |
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
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