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 salary leftpadded with 15 character long and =E2=80=98$' as special character and another column salary right padded with 10 character long with =E2=80=98@' as special character used of all employees in 201, 176 and 144.

  • SELECT LPAD(SALARY,15,'$'), RPAD(SALARY,10,'@')FROM EMPLOYEESWHERE EMPLOYEE_ID = (201,176,144);
  • SELECT RPAD(SALARY,15,'$'), LPAD(SALARY,10,'@')FROM EMPLOYEESWHERE EMPLOYEE_ID IN (201,176,144);
  • SELECT LPAD(SALARY,15,'$'), RPAD(SALARY,10,'@')FROM EMPLOYEESWHERE EMPLOYEE_ID IN (201,176,144); Correct
  • SELECT LPAD(SALARY,15,'@'), RPAD(SALARY,10,'$')FROM EMPLOYEESWHERE EMPLOYEE_ID IN (201,176,144);
Similar IT-6202 questions