Subject Re: [firebird-support] Firebird 2.0 and the ROWS clause
Author Alexandre Benson Smith
Martijn Tonies wrote:
> Hi,
> As I'm going through the huge document called "Release Notes" for
> Firebird 2.0, I noticed ROWS being implemented. Would I be
> correct as to say that it doesn't include the optional [WITH TIES]
> clause?
> Martijn Tonies


AFAIK it's a kind of alias for FIRST/SKIP (wich don't have WITH TIES too).

It just grabs the FIRST X rows in a loop and stop the loop as far it
reachs the count no matter if there are other rows with the same "level"
of sort.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil