Which of the following SELECT statements can you use?

The USER has the following fields: ID, FIRSTJMAME, LAST_NAME. FIRST_NAME, LAST_NAME have the same basic type and length. You want to compare fields FIRST_NAME, LAST_NAME to each other.

Which of the following SELECT statements can you use? There are 2 correct answers to this question. (1/1 Points)
A . SELECT*FROM users INTO TABLE lt_users WHERE first_name = users last_name
B . SELECT*FROM users AS a INTO TABLE lt_users WHERE a»first_name = a»last_name
C . SELECT*FROM users INTO TABLE lt_users WHERE first name = users »last_name.
D . SELECT*FROM users AS a INTO TABLE lt_users WHERE a first_name = last_name.

View Answer

Answer: B,C