Background documentationselect_statement Locate this document in the navigation structure


The SELECT (select_statement) SQL statement is supported in SAP MaxDB with restricted syntax (SELECT statement).

  • SAP MaxDB does not support the specification of START WITH <condition> and CONNECT BY <condition>.

  • SAP MaxDB sometimes rejects outer joins with more than two tables in the FROM clause valid in Oracle.

  • If the results in a table that are obtained from a SELECT statement are to be updateable, the syntax element FOR UPDATE must be entered.