Examine the description of the EMPLOYEES table: Which statement will execute successfully, returning distinct employees with non-null first names?

Question

Exhibit

Options

• ASELECT first_name, DISTINCT last_name FROM employees WHERE first_name <> NULL;
• BSELECT first_name, DISTINCT last_name FROM employees WHERE first_name IS NOT NULL;
• CSELECT DISTINCT * FROM employees WHERE first_name IS NOT NULL;
• DSELECT DISTINCT * FROM employees WHERE first_name <> NULL;

• A
  71% (20)
• B
  7% (2)
• C
  4% (1)
• D
  18% (5)

No community discussion yet for this question.