Subject Re: [ib-support] FIRST must be before DISTINCT
Author Ann W. Harrison
Post date 2001-09-09T16:57:21Z
At 01:58 PM 9/9/2001 +0300, raptor wrote:
>hi,
>I've just installed the FB1.0beta
>this works :
>SELECT FIRST (5) DISTINCT ....
>
>this doesn't :
>SELECT DISTINCT FIRST (5) ...

That is as designed. The FIRST/SKIP clause must
follow the SELECT.


Regards,

Ann
www.ibphoenix.com
We have answers.