[RBG7-L] - Re: Count is off

[Albert Berry]

Bernie - check this with
SELECT count(*) from inv

Bernard Lis wrote:

R>sel inmo from inv where count=last
inmo       ---------- A044884

R>sel inmo from inv where count > 1620
inmo       ---------- Z868204
Z868214
Z868214
Z868214
Z868214

The last item in the list above should be the same as the first select????

I tried this on another database and got similar results.

Can anyone verify this or tell me what I am doing wrong?

I autochk'd even reloaded and get the same result

Bernie Lis