Re: SQL Question

Tin Zaw <tzaw@qualcomm.com> wrote: :Does any one know how to do following in SQL (Informix in particular)? :I need to get the first row a SELECT statement finds, not all the rows. :e.g. SELECT * from my_table where row_value < 10 .... :should return first row with row_value < 10, even the table has :many qualifying rows. There is no direct way of doing this in Informix. If you use some language (4GL, NewEra, C...) you can allways open a cursor and fetch only the first row. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org