Hi Sergey
Could you please clarify for me how your soln. gets the LAST 1000 recs? I'd've thought that this would get the FIRST 1000 recs in the criteria.
Terry
>
select TOP 1000 unemp_ins_pct from payroll_tbl ;
> where unemp_ins_pct # 0 ;
> into array a__gen40 ;
> order by payroll_tbl.id DESC
>
>>I am selecting a bunch of records into and array as follows:
>>
>>
>>select unemp_ins_pct from payroll_tbl
>where unemp_ins_pct # 0
>into array a__gen40
>order by payroll_tbl.id
>>
>>The above select statement gives me all the records in the table. What I would like to know is how can Select only the last 1000 records in the payroll_tbl?
>>
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.