How can we limit the maximum number of rows returned by select clause
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.
Elke Zietlow 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.