#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhich of the following is the correct that display distinct job_id and the the total number per distinct (unique) job_id.

Answer

SELECT DISTICT(JOB_ID), COUNT(JOB_ID) AS =E2=80=9CTOTAL NUMBER OF JOB_ID=E2=80=9DFROM EMPLOYEESGROUP BY JOB_ID;