Shulou(Shulou.com)06/01 Report--

62, (13-17) choose the best answer

You need to list the employees in DEPARTMENT_ID 30 in a single row, ordered by HIRE_DATE.

Examine the sample output:

Which query will provide the required output?

A) SELECT LISTAGG (last_name,';') "Emp_list", MIN (hire_date) "Earliest"

FROM employees

WHERE department_id = 30

WITHIN GROUP ORDER BY hire_date

B) SELECT LISTAGG (last_name,';') "EMP_LIST", MIN (hire_date) "Earliest"

FROM employees

WHERE department_id = 30

ORDER BY hire_date

C) SELECT LISTAGG (last_name,';')

WITHIN GROUP (ORDER BY hire_date) "Emp_list", MIN (hire_date) "Earliest"

FROM employees

WHERE department_id = 30

D) SELECT LISTAGG (last_name)

WITHIN GROUP ORDER BY (hire_date) "Emp_list", MIN (hire_date) "Earliest"

FROM employees

WHERE department_id = 30

Answer:C

(parsing: the values of the checked columns will be used to overlap and display in a row. You can use listagg () WITHIN GROUP () to display the

Multiple lines are merged into one line:

)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.