Your browser does not support JavaScript!

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhat query should be used in order to display the lastname and salary of all employees whose department_id = 60 or job_id like =E2=80=98_T%'. Format the salary to be 15 character long, left padded with =E2=80=98$' as special character. Label the column Salary.

  • SELECT LASTNAME, RPAD(SALARY,15,'$') AS SALARYFROM EMPLOYEESWHERE DEPARTMENT_ID = 60 OR JOB_ID LIKE '_T';
  • SELECT LASTNAME, LPAD(SALARY,15,'$') AS SALARYFROM EMPLOYEESWHERE DEPARTMENT_ID = 60 OR JOB_ID LIKE '_T'; Correct
  • SELECT LASTNAME, LPAD(SALARY,15,'$')FROM EMPLOYEESWHERE DEPARTMENT_ID = 60 OR JOB_ID LIKE '_T';
  • SELECT LASTNAME, LPAD(SALARY,15,'$') AS SALARYFROM EMPLOYEESWHERE DEPARTMENT_ID = 60 AND JOB_ID LIKE 'T';
Similar IT-6202 questions