Re: SQL Question
Im Artikel <32C9ADCB.7F63@qualcomm.com>, Tin Zaw <tzaw@qualcomm.com>
schreibt:
>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.
>
>
Try this:
select * from my_table where rowid <
(select min (rowid) from my_table) + 10;
ciao volker