top n functionality implements compatibility with MicroSoft SQL server, Adaptive Server Anywhere, and ASIQ.
Use the top n clause to limit the number of rows in the result set to the number of rows specified by the integer. The integer can be any unsigned 32-bit value, in the range 0 through 232-1 (4GB-1 or 4,294,967,295). Zero indicates “no” rows.
Adaptive Server Enterprise, version 12.5.3 supports the top n clause in outer query select statements, but not in the select list of a subquery. This differs from the MicroSoft SQL server. Any attempt to use the top n clause in a subquery yields a syntax error.
Use top n with select...into statements to limit the number of rows inserted in the target table. This is different from set rowcount, which is ignored during a select...into.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
