Re: SQL Question

On Fri, 3 Jan 1997, James T Ford wrote: } 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. } Thanks Jim, I am using SE 7.1. A fella also gave me the following answer and it works. } Gary L. Burnore wrote: } } > select * from my_table where rowid = (select min(rowid) from } > my_table where row_value < 10) } > Thanks again and have a good day :) --- Tin Zaw x.13205 mailto: tzaw@qualcomm.com Network Engineer QUALCOMM Inc. www.qualcomm.com