The Fetch first clause sets a maximum number of rows that can be retrieved. It lets the database manager know that the application does not more than N number of rows.
Take off the Fetch First clause and count the number you want using an internal working storage field - then you can get...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.