How do I limit the number of records returned for Interbase 7.1?

Question

We have an Interbase 7.1 database and I'm trying to figure out how to limit the number of records returned by the query to just 1. I really only need to know an event code from the last record, in which the query will return hundreds of records if I cannot do some kind of limit.

Thanks in advance!

Answer 1

Does
http://scott.yang.id.au/2004/01/limit-in-select-statements-in-firebird/
or
http://training.codeface.com.br/?p=182
help?

Answer 2

I think I figured it out. Needed to do something like this...

SELECT * FROM table ORDER BY col ROWS 1