At 10:06 AM 14/07/2004 +0000, you wrote:

>Hi All!!
>
>Why if I use :
>
>SELECT FIRST 5 COUNT(*) AS COUNTER FROM TABLE;
>
>does it return the entire database record count of 8000 and not just
>5 which is selected in the 'FIRST 5' ???????

Umm....do you want to think about the logic of this for a minute and see
whether you can answer your own question?

/heLen

>Thanx!!
>
>Harry Roets
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>