| Subject | Re: [firebird-support] Firebird 2.0 and the ROWS clause |
|---|---|
| Author | Alexandre Benson Smith |
| Post date | 2006-11-08T16:27:35Z |
Martijn Tonies wrote:
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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> Hi,Martijn,
>
> 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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br