#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 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.
Answer
SELECT TRIM('A' FROM LASTNAME)FROM EMPLOYEESWHERE DEPARTMENT_ID BETWEEN 60 AND 90;