Is always regarded as a multirow set and the addition The results set of SELECT statements joined using UNION Specific statements can be prioritized using parentheses. The SELECT statements associated with UNION are evaluated from left to right. All duplicate rows are then deleted except for one (including all columns of the results set). Is specified, the rows of the results set of the right SELECT statement are If the addition DISTINCT is specified or if neither of the two additions If the addition ALL is specified, all rows from the results set of the right SELECT statement are inserted into the existing results set. The additions ALL and DISTINCT specify how duplicate rows are handled. Right side of UNION can itself contain a UNION addition and be enclosed in parentheses (Ĭlause and the INTO clause are applied to the union results set and must be specified after the position of the last closing parenthesis. The SELECT statements on the left and right of UNION The columns of the results set keep the names defined in the SELECT statement on the left of UNION. Of UNION are inserted into the results set of the SELECT The rows of the results set of the SELECT statement on the right The addition UNION creates the union of the results sets of two SELECT SAP NetWeaver AS ABAP Release 750, ©Copyright 2016 SAP AG.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |