Oracle Database SQL 12c 1z0-071 Exam Practice Test 3

Question : 25 of 50

Marks: +1, -0

You need to list the employees in DEPARTMENT_ID 20 days in a single row, ordered by HIRE_DATE.
Examine the sample output:

Which query will provide the required output?

SELECT LISTAGG(last_name) WITHIN GROUP ORDER BY (hire_date) “Emp_list”, MIN(hire_date) “Earliest” FROM employees WHERE department_id = 30;
SELECT LISTAGG(last_name, '; ') WITHIN GROUP ORDER BY (hire_date) “Emp_list”, MIN(hire_date) “Earliest” FROM employees WHERE department_id = 30;
. SELECT LISTAGG(last_name, '; ') “Emp_list”, MIN(hire_date) “Earliest” FROM employees WHERE department_id = 30; WITHIN GROUP ORDER BY (hire_date);
SELECT LISTAGG(last_name, '; ') “Emp_list”, MIN(hire_date) “Earliest” FROM employees WHERE department_id = 30; ORDER BY (hire_date)

Go to Question:

Prev Question

Next Question