Re: SQL Question
Tin,
You don't say which version of the engine you are running. If you
are running 8.1 (XPS) you may do a
select first 1 column1,column2
from t1
where .....
if you are running 7.X and below there isn't any easy way.
jim
______________________________ Reply Separator _________________________________
Subject: SQL Question
Author: Tin Zaw <tzaw@qualcomm.com> at Internet
Date: 12/31/96 4:20 PM
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.
A cc: will be much appreciated.
TIA.
--
Tin Zaw x.13205 mailto: tzaw@qualcomm.com
Network Engineer QUALCOMM Inc. www.qualcomm.com