Your browser does not support JavaScript!

Choose the letter of the correct answer based on the table EMPLOYEES as shown belowTable 10 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, LPAD(SALARY,15,'$') AS SALARYFROM EMPLOYEESWHERE DEPARTMENT_ID = 60 OR JOB_ID LIKE '_T'; Correct
Similar IT-6202 questions