>
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 propose an additional action to undo the effect of DESC:
index on payroll_tbl.id tag primary
>>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?
>>
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.