Selecting only the first row from a query

I need to write a sql statement to only return the first row that meets the criteria. For example I have a table called people with names and phone numbers. There may be several "Joel Nylund's" in the table, I only want the first one I find.

in DB2, I can do a select first

I am looking for something that will work in oracle and sybase.

thanks in advance
Joel Received on Wed Nov 29 1995 - 00:00:00 CET