Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How can we limit the maximum number of rows returned by select clause

Hi All,

How can i limit the number of rows that are returned by the SELECT clause in the MaxDB ?

I'm looking for something similar to what LIMIT clause does in MySQL.



Former Member
Former Member replied


in the documentation of the select_statement you will find the limit_clause as well:

Or you will find the top_clause in query_expression

Or you will find in the list of predicates the rowno-predicate

Therefore, there are different opportunities to restrict the number of rows.

Please pay attention to the fact, that only the rowno-predicate can be used

even in subqueries.


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question