Bernie, it looks like a sorted index on the table to me... Regards, Alastair.
----- Original Message ----- From: "Bernard Lis" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Monday, October 17, 2005 11:10 PM Subject: [RBG7-L] - Count is off > > 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 >
