At 06:36 PM 12/5/2001 +0300, Dmitry Kuzmenko wrote:

> > > SQL ROWS - Used in conjunction with the SQL ORDER BY
> >
> > Seems to be just an another name for FIRST...SKIP. Or am I mistaken?
>
>excluding absend PERCENT and WITH TIES in Firebird. Also this construction
>is used at the end of query, so it's meaning can't be understood wrong way -
>[ROWS <lower_value> [TO <upper_value>] [BY <step_value>] [PERCENT] [WITH TIES]
>applied on ready to use resultset.

Actually, tying the ROWS clause to the ORDER BY is an interesting
twist. According to SQL92, ORDER BY is part of the query statement,
but not part of the query expression. Subqueries are query expressions
so they can not include an ORDER BY. Apparently, InterBase has
relaxed that rule.


Regards,

Ann
www.ibphoenix.com
We have answers.