Arhat109,
Если юзается ASA то там FIRST | TOP n [ START AT m ]



WITH temporary-views ]
SELECT [ ALL | DISTINCT ] [ row-limitation ] select-list
[ INTO { hostvar-list | variable-list } ]
[ FROM table-expression ]
[ WHERE search-condition ]
[ GROUP BY [ group-by-list | ROLLUP ] (group-by-list) ]
[ HAVING search-condition ]
[ ORDER BY { expression | integer } [ ASC | DESC ], ... ]
[ FOR { UPDATE [ cursor-concurrency ] | READ ONLY } ]
[ FOR XML xml-mode ]

temporary-views :
regular-view, ...
| RECURSIVE { regular-view | recursive-view }, ...

regular-view :
view-name [ ( column-name, ... ) ]
AS ( subquery )

recursive-view :
view-name ( column-name, ... )
AS ( initial-subquery UNION ALL recursive-subquery )

row-limitation :
FIRST | TOP n [ START AT m ]

select-list :
{ column-name | expression } [ [ AS ] alias-name ], ...
| *

group-by-list :
{ column-name | alias-name | function | expression }, ...

cursor-concurrency :
BY { VALUES | TIMESTAMP | LOCK }

xml-mode :
RAW [ , ELEMENTS ] | AUTO [ , ELEMENTS ] | EXPLICIT