SAP
C_TAW12_740 · Question #121
Table USER has the following fields: ID, FIRST_NAME, LAST_NAME. FIRST_NAME and LAST_NAME have a same basic type and length. You want to compare fields FIRST_NAME and LAST_NAME to each other. Which…
The correct answer is B. SELECT * FROM users INTO TABLE lt_users WHERE first_name = users~last_name. C. SELECT * FROM users INTO TABLE lt_users WHERE first_name = users~last-name. See the full explanation below for the reasoning.
Question
Table USER has the following fields: ID, FIRST_NAME, LAST_NAME. FIRST_NAME and LAST_NAME have a same basic type and length. You want to compare fields FIRST_NAME and LAST_NAME to each other. Which of the following SELECT statements can you use?
Options
- ASELECT * FROM users INTO TABLE lt_users AS a WHERE first_name = users~last_name.
- BSELECT * FROM users INTO TABLE lt_users WHERE first_name = users~last_name.
- CSELECT * FROM users INTO TABLE lt_users WHERE first_name = users~last-name.
How the community answered
(31 responses)- A26% (8)
- B74% (23)
Community Discussion
No community discussion yet for this question.