Dear Ann,
Actually this has solved my problem.
Thanks!
With regards,
Carlos Arguilar
-----Mensagem original-----
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]Em nome de Ann W. Harrison
Enviada em: terça-feira, 27 de setembro de 2005 14:54
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] Retrieve the older date


Carlos Arguilar wrote:

>
> I need doing a 'select' in a SP. This statment must return the older

date of

> a date field. If the record with the older date isn't suitable, so I

need

> the second older date and so on until end of the table, if necessary.

Something like

select first 1 <date field> from <table>
where <condition>
order by <date field> desc

Regards,


Ann



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




SPONSORED LINKS Technical support Computer technical support Compaq
computer technical support
Compaq technical support Hewlett packard technical support
Microsoft technical support


----------------------------------------------------------------------------
--
YAHOO! GROUPS LINKS

a.. Visit your group "firebird-support" on the web.

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.


----------------------------------------------------------------------------
--



[Non-text portions of this message have been removed]