Re: How to select first N rows?

I have heard rumors that in 7.3 there is the folowing syntax: SELECT FIRST N * from xyz; It's true, that in many cases there is no way of knowing which are the first rows while query is executing (like the case of 'order by' ...). Yet, when sorting rows according to an indexed field, rows are fetched in order... -- _________________________________________________________________________ | | Asaf Arbely, ATG _/_/_/\\_\\_\\_ | ComSoft Technologies Ltd. _/ \\_ | 39 Ha'galim blvd, Herzelia, Israel. _/ \\_\\_\\_ | TEL: 972-9-9598961 FAX: 972-9-9598980 _/ \\_ | E-Mail: asaf@applicom.co.il _/_/_/\\_\\_\\_ | WEB: www.applicom.co.il |________________________________________________________________________