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 todisplay a report that trim the letter =E2=80=98A' from lastname of all employees whose department_id between 60 and 90.

  • SELECT TRIM('A' FROM LASTNAME)FROM EMPLOYEESWHERE DEPARTMENT_ID BETWEEN 60 AND 90; Correct
  • SELECT TRIM(LASTNAME,=E2=80=99A=E2=80=99)FROM EMPLOYEESWHERE DEPARTMENT_ID BETWEEN 60 AND 90;
  • SELECT TRIM('A' FROM LASTNAME)FROM EMPLOYEESWHERE DEPARTMENT_ID BETWEEN 90 AND 60;
  • SELECT TRIM('A' FROM LASTNAME)FROM EMPLOYEESWHERE DEPARTMENT_ID BETWEEN 60 OR 90;
Similar IT-6202 questions