--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 08:33 PM 11/02/2008, you wrote:
> >Just a short question.
> >
> >Firebird can do this:
> >
> >SELECT FIRST 250 ProductNumber, StockCount from DWIStock
> >
> >In MS SQL the same is
> >
> >SELECT TOP 250 ProductNumber, StockCount from DWIStock
> >
> >
> >Which is standard SQL ?
> >Firebird or MS SQL ?
>
> Neither.
>
> The ROWS syntax implemented in Fb 2 is standard, e.g.
> SELECT ...
> [ORDER BY <expr_list>]
> ROWS <expr1> [TO <expr2>]
>
> ./heLen
>